cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maximilian
Frequent Visitor

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 report for each year (one PBIX for each year).

Need:

The source of the information is a database that I access through Azure Blob Storage, the data structure would be the same for each PBIX file and only the specific data would change. I would connect through Azure Blob Storage and there I would find a PBIX file for each year, my need is to be able to read the information for each year within a single report and for example when viewing a year and apply a filter, if I change to another year, show me the information referring to that year with the same filter that I use.

In this graphic I explain a little more what I need:

Captura.PNG

 

3 REPLIES 3
GilbertQ
Super User II
Super User II

Hi @Maximilian 

 

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 | ...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi @Maximilian 

 

Why not create a single PBIX that has all the years?

 

You can then filter the report to have the year that you want or the PBIX can then be published with the filters in place.

 

That will allow you to only maintain one PBIX?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello, @GilbertQ thanks for answering
They have to be several .PBIX since each year has a lot of data and the client requested among the requirements that it be handled in that way, one .PBIX for each year.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors