- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
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.
https://biinsight.com/power-bi-desktop-query-parameters-part-1/
Regards,
Cherie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-12-2024 09:22 PM | |||
11-19-2024 05:44 PM | |||
06-24-2024 10:01 PM | |||
11-11-2024 07:39 PM | |||
Anonymous
| 07-18-2022 01:50 PM |
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |