How to view or track the progress of Notebook while it is running in Microsoft Fabric
How to view or track the progress of Notebook while it is running in Microsoft Fabric I was recently working with a Notebook in Microsoft Fabric that was started via a Data Pipeline. The challenge I had was that I had no idea how far the notebook had gone (as there were quite a lot of cells in this particular…
Using a Service Principal to get all Entra ID Group Members into JSON File using a Python Notebook
Using a Service Principal to get all Entra ID Group Members into JSON File using a Python Notebook Sometimes it is useful to get all Group Members into a JSON file so that this could be used for reporting purposes. Reference Notebook: Get Entra ID Group Members – Power BI In the steps below I will show you how I…
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…
Downloading Scanner API data using a Microsoft Fabric Notebook
Downloading Scanner API data using a Microsoft Fabric Notebook I was recently working with a customer where they had more then 100 app workspaces and I was running into some challenges when using the Scanner API in Power Automate. I then discovered this blog post where they detailed how to download the Scanner API data (DataXbi – admin-scan.py), it was…
How to read a Lakehouse table in another App Workspace – Microsoft Fabric
I was doing some work recently for a customer and they had data stored in different Lakehouse’s which was in a different App Workspace. I was pleasantly surprised that this can be quite easy to do. In my example below I am going to show you how in my notebook I can read a table in a Lakehouse table when…
How to stop/fix Mirroring to a database in Microsoft Fabric
How to stop/fix Mirroring to a database in Microsoft Fabric I recently had a challenge where the mirroring in Fabric stopped working because there was no activity. For me to start this again when I tried to connect to a table it said the database was already being used to mirror as shown below. Here is the text error which…
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…
Loading Fabric Lakehouse Tables with partitions
When loading data, it is always important to load the data with performance and scalability in mind. For lakehouse tables to return queries quickly and to scale it is essential to load your lakehouse tables with partitions. What I am going to show you in my blog post today is how to load data into a Lakehouse table where the…
Easily scale up or scale down your Fabric Capacity using Power Automate (Via email)
Easily scale up or scale down your Fabric Capacity using Power Automate (Via email) Following on from my previous blog post (Stop and start your Fabric Capacity using Power Automate) I got a question from Tristan as shown below! I always enjoy a good challenge and I got it working! In this blog post I will use the same method…