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.
Please confirm what I am finding. Paginated Reports must be deployed to the service with their data source pointing to the desired location. Thus, if I have a paginated report in a development environment pointing to SQL-Dev and am ready to deploy to a QA environment that uses SQL-QA, I need to change the data source in the report prior to deployment because nothing in the service or PowerShell allows me to change it after deployment. Is that correct?
Thanks for your help!
Solved! Go to Solution.
Hi @RandyPgh
" I need to change the data source in the report prior to deployment because nothing in the service or PowerShell allows me to change it after deployment. Is that correct"
Actually, you can change the data source from the power bi report builder before deploy the report to service for sure, but also there's a API which you can take a shoot to change the data source after deployment, kindly refer to the official document for more details:
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources
Hi @RandyPgh
" I need to change the data source in the report prior to deployment because nothing in the service or PowerShell allows me to change it after deployment. Is that correct"
Actually, you can change the data source from the power bi report builder before deploy the report to service for sure, but also there's a API which you can take a shoot to change the data source after deployment, kindly refer to the official document for more details:
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources
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.