Forum Discussion
Filter aggregated table with direct query datasource
Hi, I have a report built on a direct query data source. This report contains a table with products and a measure, let's say sales. This table can become very long with hundreds of products. How...
I'm sorry, I think I didn't describe the datasource correctly. My database is a SQL Server database. On top of that I have a Direct Query Power BI data model that just consists of the tables of the star schemas and the joins between the tables. And this data model is the source (Power BI dataset) of my reports. Does that change the answer to my question?