Recently, I've published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and use cases. However, sometimes it is just easier to write a blog about it to reach a bigger audience, or even record …
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
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 …
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
Back in 2019, Ton Swart and I wrote a blog post on Versioning and CI/CD for Power BI with Azure DevOps. Back then, there were not many options available for versioning and professionalizing your ALM story for Power BI. Till today, this blog post is still my most read blog on Data-Marc.com which makes us …
Continue reading Integrate Power BI Deployment Pipelines with Azure DevOps
If you want to refresh a Power BI dataset, we all know where to find the refresh button in Power BI Desktop as well as in the Power BI Service. By clicking it, you will trigger the entire dataset to refresh. But sometimes it is more convenient to trigger a single table to refresh. If …
Continue reading Trigger a single table to refresh in the Power BI Service
Getting more insights in the telemetry of your Power BI dataset is always interesting. Especially if you share your Power BI dataset for self-service purposes to build new reports on top of your managed dataset, you might want to know who is actually using in and what queries are they executing against your datasets. Besides …
Continue reading Analyze active sessions and cancel refreshes in Power BI
In my previous blog, I wrote about using Tabular Editor to migrate existing (Azure) Analysis Services models to a Power BI data model. This is pretty awesome already! Once you moved your model to Power BI, you can also start using the functionality of the entire platform. One of the most useful features is dataflows …
Continue reading Bring existing tables to Power BI dataflows with Tabular Editor
Power BI (Premium) now offers a native migration option to Power BI. I recommend first exploring that, before taking this approach. You can find more details here. Also read this blog around migration, how and why. Over the last two weeks, I had the pleasure to work on an innovative case where we wanted to …
Continue reading Migrate Analysis Services models to Power BI using Tabular Editor
Data - Marc 