Dataset as parameter ?

[Anonymous]

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 ?

[Anonymous · Accepted solution]

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]

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]

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

Then i get a screen with all my datasets

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

[ankurverma]

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]

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.

Normal Direct Query:

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.

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]

@Anonymous , refer if this blog can help

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