Forum Discussion
Automatically change data sources
Hi Keny ,
In Power BI, you can streamline switching data sources between development and production environments by using parameters and configuration files. Here’s a summary of the steps:
Create Parameters: Define parameters for parts of your data source connection that change (e.g., server name, database name).
Use Parameters in Queries: Modify your data source connections to use these parameters in Power Query Editor.
Create a Configuration File: Make a file (e.g., Excel or JSON) that contains different environment configurations.
Switch Environments Using Parameters: Load the appropriate environment settings from the configuration file into the parameters.
Automate Parameter Updates: Use Power Query M code to dynamically update parameters based on the selected environment.
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters
Unfortunately, there is no easy way to change the data source to power BI reports as of now without Fabric subscription.
If both your Test and Production workspaces are assigned a fabric capacity, you can create a deployment pipeline in Power BI service.
It lets you change data sources and parameters for each stage of deployment.