Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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