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

New Course Release – Advanced Data Transformations & Modeling

You can view details around the new course here – Advanced Data Transformations and Modeling Exciting times here at Enterprise DNA as I’m releasing yet another course into Enterprise DNA Online. The Advanced Data Transformations and Modeling course has been a work in progress for some time as I wanted to make sure that I

Continue reading