About

IMG_20191020_132213

Bill Anton is a beaver. Unlike traditional beavers, who waste their time in the woods splashing around in streams with sticks, Bill spends his time building enterprise-grade data warehouses and semantic layers. He has a grasp of DAX that surpasses all other beavers (and most humans).

2 replies on “About”

Hi Bill,

This is Cairo Henrique from Brazil.

I have a question to you as a Consulting guy. Do you see any chance of using a table component (or a custom created one) that do not automatically creates a Dax query based on SUMMARY?

I use 50GB AAS and need to show a table on its row detaill. (imagine a table with 200MM rows and no relationship) – when I put some collumn on a table componnent on Power BI, it automatically creates a group by internal query. I want to avoid that because all my rows are different and this cause a performance problem.

If I create a query on Dax Studio showin the top 1000 rows of this table, it is fast. PBI always whant to show TOPN of summarized data.

Like

Hi Cairo – have you considered a different approach such as adjusting the model and/or report design?

re: modeling
how many columns are in the 200mm row table?
are all rows completely unique – as in different values for each column?
would any of these columns make sense in a separate dimension?

re: report design
who is the intended audience for this report and what are they trying to accomplish?
would this report make more sense as a “paginated report”?

Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s