Tag: Power Query

How To Organize Your Power BI Models – Best Practice Tips

How To Organize Your Power BI Models - Best Practice Tips

I wanted to highlight in this post some of my best practice tips when organizing detailed Power BI models. You’ll find as you work through any development, elements of your Power BI reports will grow. This can be things like new tables of data, differing relationships between tables, an assortment of measure groups and much

Continue reading

My Practice Tips When Using The Advanced Editor in Power BI

We’re going to talk about some of my best practice tips using Advanced Editor inside Power BI. Surprisingly, most people don’t know about the Advanced Editor. It is because it’s hidden away inside the Query Editor which a lot of users don’t utilize as much as they should. If you don’t know what it is,¬†you

Continue reading

Optimizing Power BI Tables using Query Parameters

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but there are some occasions where it’s better to do this at the query level versus the report level. You might want to create filters at the query layer if you have massive

Continue reading