Skip to main content

Power BI

Needs Votes

Create aggregated tables with the new Direct Query to Power BI dataset feature

Vote (2) Share
Blake Slattery's profile image

Blake Slattery on 24 Mar 2021 20:21:29

Recently the feature to be able to connect and "extend" Power BI datasets with your own data was released.

This is a great feature but one piece that would really enable our use of this is to be able to create aggregated tables (using the Power Bi Aggregations functionality) off of the tables in the original dataset.

A great use case for us would be to:
- Build a model with our required directquery fact tables, dual dimension tables
- Extend that model with the new "Direct Query to Power BI dataset" feature to add imported aggregated tables in the new datasets

That way we can centrally manage one "large model" from an enterprise perspective, and have developers and self-serve users build their required imported tables off of it without impacting existing datasets

Comments (1)
Blake Slattery's profile image Profile Picture

Craig Wigan on 25 Mar 2021 17:59:27

RE: Create aggregated tables with the new Direct Query to Power BI dataset feature

This would be great. I have managed to do this using selectcolumns on a new table from the directquery table. It refreshes fine in power bi desktop, but won't allow the ability to refresh in the power bi service online i.e. scheduled refreshes.

Great if you want to build onto a pipeline of 'one source of the truth' and connect to various other elements, but sometimes only using a subset of that data.