Recently, I posted a poll on Twitter to vote for new blog topics. One thing that popped-up in my mind, was more on the governance side of Power BI. A topic where I spend a lot of my day-to-day time, but is maybe less interesting for others? At least that is what I thought. Below …
Continue reading Power BI Governance – Why you should consider to disable Export to Excel
Imagine that you are building a Power BI dataset for corporate reporting, that will also be reused for self-service purposes by many others. It is up to you, as dataset author, to make it as simple as possible for them to reuse your content and avoid misunderstandings. In this blog I will give more detail …
Continue reading Share your Power BI dataset and spice up your table and column names
Lately, I published the first out of two blogs about monitoring your on-premises data gateway. The first blog was all about monitoring your gateway up time but doesn't tell you when one of the connections on your gateway is down. This blog will go in more detail how you can monitor your data source connectivity …
The drill through functionality is in Power BI for a long time and already made huge steps forward. Though, one of the most challenging things with this very valuable feature was the discoverability. Hidden behind the right-click, not every user was able to use this feature or not even know that it is there. Let me take you through the biggest game-changers for drill through in Power BI and close-off with the recently launched (preview) feature in the March 2020 release!
Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in order to refresh your dataset in the Power BI service. This additional component, does not have out-of-the box monitoring functionality. But why not …
Natural language query was probably the most unused feature in Power BI, until they introduced the new Q&A visual in the end of 2019. I'm a huge fan of this feature, but it is sometimes a bit challenging to implement. Especially working with end-users from different background in different countries. Back in September 2019, I …
Continue reading Synonyms, the secret behind Power BI Q&A and Natural Language Query
As a Data & Analytics consultant, working on tons of different projects, it is very likely that I'm the creator and owner of a whole lot of dataflow and dataset refreshes. Since these refreshes can only be managed by the owner, this limits the rest of my colleagues from updating the scheduled and maintaining the …
Continue reading Manage all your Power BI refreshes in one place with Power Automate (Flow)
The year flew by pretty fast! With 2019 in the books, it's time to have a look back at all awesomeness that happened this year! Time to say goodbye to 2019 and welcome 2020 with a short look ahead to everything that's coming up! EventsAfter 5 events in 2018, I started to like the public …
As Power BI enthusiasts and consultants, we are building tons of reports. All with the goal to enable the business to take data driven decisions by providing them with the right information at the right time. Though, if your reporting audience is growing, there is no way to satisfy all your users. Of course, the …
Over a year ago, I wrote a blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. This blog will continue this story in more detail of Power BI CI/CD with Azure DevOps automated deployments. A solution where Dave Ruijter, Ton …
Continue reading Versioning and CI/CD for Power BI with Azure DevOps
