Power BI Goals, a new way in tracking your KPI’s
Power BI has always been about making your data visible. By creating pie charts, line graphs, tables, and all other kinds of visuals, you can show organizations their performance in finance, sales, you name it. With KPI Cards you can show if they’re on track with their target, and with alerts in dashboards, you can … Continue reading Power BI Goals, a new way in tracking your KPI’s
Power BI buttons & bookmarks
When I started as a BI consultant, the only way to create page navigation in Power BI was by using bookmarks and my other main use for bookmarks was creating a “Clear filters” button, to reset all my slicers in a report. In this article, I’ll show some extra usage for buttons and bookmarks. Relative … Continue reading Power BI buttons & bookmarks
Power BI datasets and Object Level Security (OLS)
I once had a customer who had a large collection of data from different subsidiaries. These companies were only allowed to see their own, anonymized data, but the Security Officer of the main company also needed to see the Personal Information (PI) of all employees. Eventually we “solved” this by creating two reports, which also … Continue reading Power BI datasets and Object Level Security (OLS)
Showing Microsoft Forms results in Power BI
A few days ago, someone asked me to think of a solution to show the responses of a Microsoft Form in Power BI. During this project, I used Forms, Power Automate, Excel, OneDrive, and of course Power BI. I found some interesting obstacles that I want to show you, but first, I start creating a … Continue reading Showing Microsoft Forms results in Power BI
Automated Testing of Azure Data Factory Pipelines
Improve the quality of your solution from a DevOps perspective Developing ETL or ELT solutions in smaller or larger teams has never been easier with the help of DevOps. It enables us to be certain that the solution still works after multiple team members made changes in different parts of the solution. For example changes … Continue reading Automated Testing of Azure Data Factory Pipelines
Exporting all your Power BI reports at once
A few weeks ago one of my colleagues showed me a PowerShell script to export all Power BI reports from a Power BI Workspace. This could come in handy for back-up purposes (version control is still hard to accomplish) or if you don’t have access to the PBIX files via the normal way and you … Continue reading Exporting all your Power BI reports at once
Copy Outlook Calendar Events with Logic Apps or Power Automate
Automatically sync multiple Outlook Calendars to one ‘main’ Calendar Working as a consultant sometimes means having multiple mail addresses and calendars to manage. Up until now, I added Calendar events from my client manually to my ‘main’ calendar, just to keep it up to date for my colleagues and avoid two meetings at the same … Continue reading Copy Outlook Calendar Events with Logic Apps or Power Automate
Adding external users to your Power BI Workspace
A question I often get is how companies can share Power BI reports with external users, and how they can participate in a workspace. In this story, I’ll show you! The Problem When I want to add an external user to my workspace, I get the following error: I’m very sure that I haven’t added … Continue reading Adding external users to your Power BI Workspace
Sending alerts to notify your whole team
In my previous post, I explained how you could create variable thresholds in Power BI for your alerts. In this post, I will explain how you could notify your whole team that something is wrong. For example, if you are working with a data warehouse and want to inform your team that the latest data load has … Continue reading Sending alerts to notify your whole team
Exploratory Data Analysis with Azure Synapse Analytics
Build a Power BI Report on Parquet files with the Serverless SQL Pool Last week, 3th of December, Azure Synapse Analytics was announced to be General Available. Another reason to have some fun with a few of the new features in the Azure Synapse Workspace. Like building a Power BI report with T-SQL without provisioning … Continue reading Exploratory Data Analysis with Azure Synapse Analytics
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow my stories
Receive new stories directly in your inbox!
