Last week I was running a post-conference (postcon) workshop at Fabric February in Oslo. To have a successful postcon, workspaces were needed for all attendees of the workshop. In these workspaces they had to run their exercises and explore Fabric. But setting up a bunch of workspaces by hand, assigning it to a capacity and …
Continue reading Behind the Scenes: How I Automated My Fabric Workshop (training)
Last week, I was attending and speaking at the first ever Fabric February, a great in-person conference dedicated to Microsoft Fabric taking place in Oslo - Norway. (I recommend attending future editions of this event!) During the conference, someone walked up to me and asked if I knew a way to programmatically refresh Power BI …
Continue reading Can you refresh a Power BI Datamart Programmatically?
Lately, I found myself struggling using the Power BI REST API to add a service principal to the (Fabric) workspace. After I engaged with some other folks, I managed to succeed. In this blog I will elaborate on the mistake I made and how I got it to work. For some this might be a …
Continue reading Add service principal to Fabric workspace using Power BI REST API
Imagine, you have everything setup and well secured in your data lakehouse, or data warehouse if you will. Then a user starts consuming the data in Power BI and imports all data according to the security applied to that users' permissions. Once the data is imported, all data can easily be shared to others who …
Continue reading Simplifying Security Replication in Power BI: A Step-by-Step Guide
Especially in this time of the year, you will encounter many similar kind of questions as a Power BI Service Administrator. Questions like: "My colleague is on vacation, but I don't have access to the workspace and the refresh broke, can you help me getting access to this workspace?" Well, this is still the simple …
Continue reading Add user to Power BI deployment pipeline using REST APIs
Basically for every data model, but in particular for large and enterprise-grade data models, it might be wishful to perform backups. Power BI Premium offers a way to perform backup and restore operations for Power BI datasets. This feature, coming from Azure Analysis Services, helps you to take a backup of your dataset logic as …
Continue reading Script and automate Power BI Backup operations
Recently, I encountered a situation at a client where the Power BI reports where previously bind to Azure Analysis Services, but now the reports became inaccessible. This was because the Analysis Services model was migrated to Power BI Premium, but the reports where not yet connected to the new data model. Unfortunately, since the Analysis …
Back in February, I wrote a blog on how you can trigger a single table to refresh in your Power BI data model. This blog described how you can achieve this goal using a PowerShell script and the ASCmd cmdlets for Analysis Services, which also works for Power BI Premium. In the wrap-up of that …
We have all been in a situation where you want to get more insights in the specific settings for a published dataset. But when this dataset is owned and published by someone else, you have to take-over the dataset first to get all the details available. In this blog, I will elaborate on what is …
Continue reading Insights in Power BI dataset parameters and refresh schedule
A while ago, I wrote a blog about migrating Analysis Services dataset to Power BI Premium. Back then there were not many options to do so, today there are many more like ALM toolkit. Though, the read is still useful to get the concept behind it and understand the similarities between Azure Analysis Services meta …
Continue reading Swap connection from Analysis Services to Power BI dataset
Data - Marc 