Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
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.
Thank you,
Sau
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:
Deployment pipelines overview - Power BI | Microsoft Docs
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.
Thank you.
@Anonymous
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.
Microsoft Idea · Power BI deployment pipelines (Preview) 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:
PowerBI - CICD using Azure DevOps - Microsoft Power BI Community
Hi @Anonymous ,
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq ,
You mentioned that PowerShell cmdlets might help in automating this task?
Did you have New-PowerBIReport cmdlet in mind?
Thanks,
Sau
I wonder if the REST end point 'Rebind report in Group ' can do the trick.
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup
There is this REST API for updating data source.
Datasets - Update Datasources In Group (Power BI Power BI REST APIs) | Microsoft Docs
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.
Thank you,
Sau
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!
Hi @_sfrost ,
Just checked once more. I am on March 2021 version
Preview feature turned on
The parameter options are grayed out.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.