Forum Discussion
Access multiple datasets from the same report
Context: The project that I am developing consists in that I have the sales data of various products for several years, but being so large the amount of data was divided and now there is a different...
GilbertQ
Super User
Super UserHi Anonymous
What I would then do is you can create another PBIX which has got all the years?
This would make it really fast when used.
You could try and composite models, but this could potentially be slow because it will have to query across multiple datasets when a change is made.
Here are more details: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI