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
How cool would it be to sketch your architecture designs for Power BI directly with the icons related to the product? It makes it a lot easier to handover the solution design to others who can then build the solution. Besides that, it also looks super fancy! I am happy to say that as off …
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
Missed the announcements from the Microsoft Business Application Summit? With this post I want to share the, what I believe, are the most exciting and impactful updates for Power BI that are announced during Microsoft Business Application Summit. Below a brief summary of what’s coming and why this is so super exciting! FastTrack Recognized Solution …
Continue reading My favorite Power BI announcements from the Business Application Summit
I'm proud and humbled to share that I have received a recognition as FastTrack Recognized Solution Architect among 32 others worldwide. After submitting my profile and passing the review process by the Power Platform engineering team and the Power BI Customer Advisory Team (CAT), I received this amazing news. This recognition stands for "practicing solution …
Continue reading Proud and humbled! Recognized as FastTrack Recognized Solution Architect
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
As it is not likely that anything will change anytime soon, we are probably working from home for the coming period. Although I had a pretty good home office already and not much to complain about, still I decided to up my game and upgrade my home office. You might think, "huh... normally he writes …
Data - Marc 