Showing results for 
Search instead for 
Did you mean: 
halfrican008 Occasional Visitor
Occasional Visitor

Template for multiple datasets?

Good morning! First, I would like to say that I am very new to Power BI and I apologize if I use the wrong terms. 


Basically, I am trying to figure out a good way to create a template that will display information from any dataset that I choose. Currently, I am using Alteryx to create a powerpoint for a specific Drug at a specific store. The powerpoint is then reviewed and a determination is made. What I would like to do is have Alteryx create a standardized excel file that can be selected in power BI to populate the report. 


The part that I am unsure of, is how to make a report with an interchangable dataset. I am also open to creating a report that connects directly to the database, but I am not sure how to make it easy for the end user to do. Currently, in Alteryx I have it set as an iterative macro, which pulls each store and drug combo and then creates a powerpoint for that. In a perfect world, I would love if I had the ability to input a store number and an NDC into a field in the report, and it updated the WHERE statement in the query.


Not sure if either of these are things that can be done in Power BI, but I thought that I would give it a shot.


Thank you in advance!

v-cherch-msft Super Contributor
Super Contributor

Re: Template for multiple datasets?

Hi @halfrican008 


It seems you want to change the source path dynamically,right?If so,please refer to this similar post.Below is the article for more details.




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 46 members 1,266 guests
Please welcome our newest community members: