Call today 0845 643 6463

Tag Archive: DAX Studio

  • There Is More Than One Way to Query Your Data: Have You Tried DAX?

    June 12th, 2026 in Blog, Data analytics, DAX

    Power BI is fantastic for building reports, but sometimes you just need to get data out of a semantic model quickly, without building a full report page to do it. However, what if you need to dig further into a specific snapshot of your data? For example: What if you wanted to pull a precise slice of data into Excel for a one-off analysis? Or maybe you’re building a bespoke report and want to make sure it’s using the same agreed…

    » Read more

  • Learning through ‘Unconventional’ Power BI Projects

    Learning through ‘Unconventional’ Power BI ProjectsJuly 1st, 2024 in Blog, DAX, Just For Fun, Power BI, Power Query

    When we think of Power BI projects we typically think of solving business problems through creating insightful analytical reports and dashboards, Power BI is fantastic for this. However, when trying to expand your knowledge on the functionality of Power BI, I have found it incredibly useful to think outside of the scope of these types of project and explore other ways to use it. In this blog I will show an example of an unconventional Power BI…

    » Read more

  • Making the DAX Engine Work for You

    December 3rd, 2021 in Blog, DAX, Power BI, Uncategorized

    In my last blog post which can be found here, I demonstrated that it’s important to limit your DAX filters to specific columns rather than entire tables, now we know that we can and should do it, let’s explore why and how it works. There are numerous ways to write an expression that will give the same result set, but why are some ways more efficient than others? To answer that we need to know a little about what happens under the hood,…

    » Read more

  • How to export more than 30,000 rows of data from Power BI Desktop.

    June 21st, 2021 in Blog, DAX, Power BI

    Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as expected but ran into this error message: “Data exceeds the limit – Your data is too large. Some data sampling may occur”? Most probably this has occurred because you’ve got more than 30,000 rows of data in your table that you’re trying to export. In the example shown below I’ve actually got 30,001 rows…

    » Read more