Understanding what is consuming your Fabric Storage
This blog post will show you how to understand what is consuming your Fabric Storage. If you want to know how I got this data, please read my previous blog post View all your Storage consumed in Microsoft Fabric – Lakehouse Files, Tables and Warehouses – FourMoo With this Semantic model below, I could also create alerts to notify based…
Did you know external (Guest) users can connect to your Semantic Model using Excel?
Yes, you read that right, it is possible where you have shared Power BI semantic model with an external (guest user in Entra ID) they can now connect to the semantic model using Excel. This has been around for quite a while I just did not know about it, here is the Microsoft documentation: Semantic model connectivity and management with…
How to get data from a Fabric Lakehouse File into Power BI Desktop – Using Scanner API JSON
How to get data from a Fabric Lakehouse File into Power BI Desktop – Using Scanner API JSON In this blog post I am going to show you how I connected to my Scanner API JSON file which is stored in the files section of my Microsoft Fabric Lakehouse. Full credit on how to complete this comes from Marc’s blog…
Semantic-Link-Labs – Automate updating your Incremental Refresh Policy for your Semantic Model
The scenario here is that quite often there is a requirement to only keep data from a specific start date, or where it should be keeping data for the last N number of years (which is the first day in January). Currently in Power BI using the default Incremental refresh settings this is not possible. Typically, you must keep more…
Using Sempy to Authenticate to Fabric/Power BI APIs using Service Principal and Azure Key Vault
I have been doing a fair amount of work lately with Fabric Notebooks. I am always conscious to ensure that when I am authenticating using a Service Principal, I can make sure it is as secure as possible. To do this I have found that I can use the Azure Key Vault and Azure identity to successfully authenticate. By using…
Did you know you can create DAX measures directly in the Power BI Service using Visual Calculations
There have been some updates to Power BI with Visual Calculations, and as of the March 2024 release you can now create and edit visual calculations in the Power BI Service. Here are details from the blog post: Power BI March 2024 Feature Summary | Visual Calculations Update I then saw an email which made me think, could I then…
Power BI Report for Microsoft Fabric Support Page
This will be one of my shorter blog posts What I wanted to show you is that I have created a Power BI report which shows the Microsoft Fabric Support page details. I created one for Power BI which I receive daily, and it is great to get the subscription so that I am aware of any potential issues or…
How to schedule a Power BI dataset refresh to start at the exact time you want it to start
I have seen some questions in the Power BI / Fabric Community forum asking why datasets with a scheduled refresh do not start based on the user’s selection. In this blog post I am going to show you how you can schedule a Power BI dataset to start at the exact time you want it to be refreshed. Please NOTE:…
Power BI Dataset refresh failed with Personal Cloud Connections
This week I was working with a customer where they had a dataset that was previously refreshing successfully and not it failed. It failed with the error “Due to consecutive errors, scheduled refresh has been disabled. Please resolve the error on the dataset and then re-enable.” If the refresh fails too many times it also disables the scheduled refresh. When…
How to create and use keys (A work around for Primary Keys) in Fabric data warehouses
When I started looking into using the data warehouses feature in Fabric, I did see that there were limitations on Primary Key columns. Below is my blog post on how I still use keys in my data warehouse, instead of using GUID’s which to me are long and hard to use. In my example I am going to create a…