cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CaveOfWonders
Helper II
Helper II

Create One Report That Can Switch Between Multiple Datasets (Excel Workbooks)

I have around 300 different datasets (Excel Workbooks); the structure of the data within the workbooks is exactly the same, but the content differs depending on the project. All the workbooks are sitting in the same directory within SharePoint.

 

I have created a report based on one of the workbooks.

 

Essentially my question is, is it possible to allow clients to dynamically switch between datasets within the report, i.e., if they are viewing data relating to project #1 and want to see data relating to project #200, they could use a drop down or a search bar to find #200 which would refresh the data in the report to look at the data for that project.

 

This has to be possible in Power BI Desktop. I cannot use the service. There are no data source alternatives at the moment.

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @CaveOfWonders ,

 

Does Using Query Parameters in Power BI Desktop meet your requirement?

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @CaveOfWonders ,

 

Does Using Query Parameters in Power BI Desktop meet your requirement?

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Greg_Deckler
Super User IV
Super User IV

Seems to me you want to use a Folder query. This imports everything in a folder and appends it all together. Then you can use a slicer as you are discussing.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Hi Greg, thank you for your prompt reply. Preferably no, we don't want to do that, we'd like to be able to switch between datasets dynamically and not have to bring all the data in to one workbook.

 

But I've also just checked, it's not feasable to do so with sharepoint as it doesn't let you specify a folder. It brings in everything in that sharepoint. Please correct me if I'm wrong.

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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.