Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Dataset as parameter ?

I have 1 report which i use on multiple (customer)datasets 

At the moment i change the Power BI dataset in the report and then deploy the report to an embedded environment.

 

Is it possible to use a parameter for my dataset so i can deploy the report and change the dataset in the settings ?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

The solution might be found in binding datasets.

We are going to let someone look into this.

 

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/bind-report-datasets

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

The solution might be found in binding datasets.

We are going to let someone look into this.

 

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/bind-report-datasets

Anonymous
Not applicable

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

 

Best Regards,

Rico Zhou

Anonymous
Not applicable

I dont want to change a datasource like a table or something. I want to change the entirce link to a dataset

 

Manually i do this. My current Data source is a allready published dataset containg my entire model.

My new datasource i that another (identical) model but with different data.

 

So i press the Transform data button and see this

 

remyo_0-1614078451468.png

 

Then i get a screen with all my datasets

 

remyo_1-1614078684801.png

 

 

I select one and then i publish.

 

 

 

I would rather like to publish my report and be able to change the link to the dataset afterwards.

This would save me a lot of time

one way I was able to achive this by writing a program to extract pbix files, change JSON in Connections file, then add it back into zip (named .pbix). since I have a bunch of reports this program speeds up things as compared to changing 1 report at a time thru Power Bi desktop.  

Anonymous
Not applicable

Hi @Anonymous 

You want to dynamiclly change the dataset(data source) in service by parameter.

Your demand is a good idea, while it is not supported to implement in Power BI currently.

Get data from power bi dataset is live connection mode.

Though DirectQuery for Power BI datasets is accessable.

We couldn't find the Queries in Power Query Editor like normal Direct Query,when we add a local mode in desktop.

1.png

Normal Direct Query:

2.png

So we couldn't use parameter to dynamiclly change the data source when we use Power BI Dataset as data source.

Change dataset manually by data source setting is a good way.

3.png

You can vote up this idea for this function:manage parameters in Power BI Live connection

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

amitchandak
Super User
Super User

@Anonymous , refer if this blog can help

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors