Query catalog of a Power BI workspace with Azure Functions

Hi Power BI folks! This time we wanted to share some code that can help you if you manage a Power BI tenant, and you want to document the underlying queries of those datasets, for which we will create a query catalog of a Power BI workspace. We ran into this need ourselves when we were troubleshooting a CPU-expensive query that was hitting one of […]

Read more... Leave comment

Naming convention for Power Query steps

Some thoughts about correctly naming your Power Query steps, to improve readability and contextualize your data, so you can make sense of the process just by looking at the step names.

Read more... Leave comment

Avoid Changed Type steps when Adding Columns in Power Query

Hi Power BI Folks! Welcome to our very first blog post here at daxproservices.com. This will be the start of a great journey of Power Platform posts together. I just wanted to share a tip that will help you save some steps while writing your Power Query queries, especially if you are not familiar with M formulas and the Advanced Editor. Goal We are going […]

Read more... Leave comment