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?
Recently, I had two enterprise customers with whom I was in conversation about Microsoft Fabric and how it could complement their existing data landscape. Both of these customers have a data platform running already, which have lots of best practices and customizations in it, not necessarily portable to Fabric. Also, both came from a standpoint …
In the previous blog, I wrote about data temperature as part of Fabric when you're using Direct Lake storage mode. In that blog, I explained how you can get insights in the temperature of a column, what that temperature means and what the impact of the temperature is on columns that are queried more often. …
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
Most of us probably know, but every now and then, I still run into cases where hiding pages in a Power BI report is used for security purposes. Although hiding pages might seem like a security feature, it is not intended to be used as one since it can be easily bypassed. Users can find …
Continue reading The Truth About Hiding Pages in Power BI Reports: Why It’s Not a Security Feature
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
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 