Power BI
Needs VotesCreate aggregated tables with the new Direct Query to Power BI dataset feature
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)
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.