Automatically change your Power BI theme by the time of the day
Make your report look different depending on the time of the day with some very easy measures and one API.
Monitor Synapse Notebooks from a Microsoft Teams Channel
Working with Spark Notebooks in Azure Synapse Spark can be challenging, especially when it comes to detecting errors in various types of for loops. While you may aim for a successful notebook execution, it’s often necessary to identify and address the functions that failed. One way to efficiently monitor notebook execution without failing the entire…
Using Power BI Visuals inside your PowerPoint presentation
Using a Power BI report page or visual inside PowerPoint is very easy and handy to use.
Show lineage between the tables on an Azure SQL DB and a Power BI Dataset
Microsoft Purview is a very powerful tool for data curators, and with enabeling column level lineage for Azure SQL DB’s to Power BI datasets, it got even better!
Loading your Cosmos DB data into a Synapse Spark Notebook
What is, in my experience, the best way to get data from Azure Cosmos DB. In this blog, I will provide examples of how to set up a connection to Azure Cosmos DB in Azure Synapse Notebooks. And explain the difference between the analytical store and the operational store. In my current project, I’m working…
Power BI & Microsoft Purview: Showing ‘full’ lineage from source to report
Microsoft Purview gives you a nice way of viewing the lineage from a datasource all the way to your Power BI report. In this blog I’ll show how you can enable this, using Apache Atlas API.
Analyzing Teams data over a full year
How can you see all of your MS Teams statistics over a full year and what information can you get out of that? Let’s find out!
Using Paginated Reports in Power BI
Since paginated reports will become availible for Pro users, it’s time to see how you can create your first one!
How to CI/CD Synapse Serverless SQL
A custom solution with Python and Pandas for an incremental deployment. In this post, I will explain why I created a custom solution and how to use it. All code can be found in my GitHub Repository, linked at the end of the post.
Adding external users to your Power BI workspace — Update
In one of my first blogs, I describe a method of how to add external people to your Power BI workspace. You can read that one here. Now there is a problem with that. Before, you got an e-mail with a link to that specific workspace and could access the content. When you click on the…
Something went wrong. Please refresh the page and/or try again.
Follow my stories
Receive new stories directly in your inbox!