Knowledge Base
Zebra BI for Power BI

Generate a DAX query for your Power BI dataset in minutes

Applies to:
Zebra BI Tables for Power BI

Let’s see how to generate a DAX query from your Power BI dataset in just a few minutes, which you can use to connect to Zebra AI.

Prerequisite: You’ll need the Power BI Desktop application.

Once you open Power BI desktop, you’ll need to somehow connect to a Power BI semantic model: either through a live connection or by opening a .pbix file.

Once your data is connected, drag in all the fields you’d like Zebra AI to analyze into a native PowerBI table visual. For best results in Zebra AI, use one datetime field, multiple categorical dimensions and a few numerical measures. For datetime fields from calendars, make sure they are represented as a simple “Date” string and not “Date Hierarchy.”

Dragging data fields into a native PBI tables visual
Change Datetime fields from Date Hierarchy to Date (before)
Change Datetime fields from Date Hierarchy to Date (after)

Finally, let’s turn off totals in the PBI table format pane for a better result.

Alright, we’re ready to generate our DAX Query! Go to the “Optimize” tab at the top of PowerBI, then select “Performance analyzer”, then “Start recording” and finally “Refresh visuals”, expand the “Table” tab and there you’ll see the option to Copy query!

You can use this query directly in Zebra AI, when connecting to your dataset. However, you will probably want to edit a small part of your query before running it. Specifically, increase the first argument value in the “TOPN(“ part of the query from 501 to something which will exceed the total number of rows in your dataset. Note that you’ll only be able to load a maximum of 100000 rows or 1 million values per query, and a maximum of 15MB per query. For more information on the limitations imposed by Microsoft, see this page.


Was this article helpful?