Forum Discussion
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 ?
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
6 Replies
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
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.
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 , refer if this blog can help
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
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
