Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Dataflow
Need Help
Tips and Tricks
Tutorial Requests
GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Anonymous 

 

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • colonel_claypoo's avatar
      colonel_claypoo
      Frequent Visitor
      5 years ago

      Hi Anonymous,
      have you found a solution to your problem yet? I'm also looking for a way to be able to choose from multiple data sets within the same report.

       

      Thanks.