Please consider the following scenario:
My company is on Professional edition.
We envisage several Power BI reports which are developed around a single Power BI dataset (Dev-Dataset) . These are all in the Dev-Workspace.
After testing and user trials, I would like to copy over these reports to a Prod-Workspace and have them point to the production Power BI dataset (call this Prod-Dataset)
Doing this manually ?
Automating the above?
Is it possible to automate the movement and re-pointing from Dev to Pro using some tool or scripting such as Powershell ?
The manual steps are too many and error prone. We want to make the development process more productive because we need to do this for every sprint cycle.
I believe it's the concept of Deployment Pipelines, a newly introduced feature in Power BI
You can automate the process of pushing the content from Development > Test > Production with few clicks.
Please refer to the below doc if that helps:
Remember this is Premium Only feature.
Please accept this answer as solution if in case my suggestions helped you!
Hello @_sfrost ,
I did consider this. Our licenses are Professional at the moment. At our current scale of operations, I cannot see us paying hefty premium fees.
Then I'm afraid the only possible way I can think of right now is to udpate the source manually.
You can upvote the below idea incase if you would like to see this feature available for Pro users.
There might be another option you can investigate further (haven't tested it. I just think it's worth a try)
We can actually automate few kind of Power BI Actions with Azure DevOps in combination with Power BI REST APIs and PowerShell cmdlts, as explained in the below community forum:
Hi @sau001 ,
There is not a really clean way to do that as far as I know but you can no doubt create a Power APp or Power Automate or even PowerShell to do this. However, I think it would be easier and quicker to change the source to use a Parameter. You would have the initial setup time but after that it would be just changing one Parameter per report to point to the new datasource.
I wonder if the REST end point 'Rebind report in Group ' can do the trick.
There is this REST API for updating data source.
But that doesn't list the Power BI Dataset as source in the list of supported data sources.
Hi @collinq ,
I did make an attempt at creating a parameterized report where the parameter points to another Power BI dataset which has been published on Power BI service.
However, I was unable to find any UI option that would allow me to do that. Here is a screen capture of a report immediately after selecting an online Power BI dataset as a data source.
You can see that the parameters options have been grayed out.
March 2021 Power BI Desktop Version supports Direct Query for Power BI Datasets. May be you can try that check if you can see parameters option enabled?
Make sure to enable this option in Preview Features in case if you are trying!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps