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.
I have a power apps solution with tables and dataflows. these dataflows use tables from other solution within the Dev environment. when the solution is moved to QA, how do I change the source connection of the dataflow from the table in Dev to table in QA
Solved! Go to Solution.
Hi @KethanVM
Here's a concise action plan to help you change the source connection of a dataflow from a table in Dev to a table in QA:
Open the Dataflow in the QA Environment: Navigate to the Power Apps solution in your QA environment where the dataflow is located.
Edit the Dataflow: Select the dataflow you wish to modify. Look for an option to edit or configure the dataflow. This will open the dataflow editor.
Change the Source Connection: In the dataflow editor, locate the source connection settings. You will need to update the connection settings to point to the table in the QA environment instead of the Dev environment. This might involve selecting a new data source and providing the connection settings for the QA environment. Then use the new data source's connection information to replace the old queries' data source information. You can modify the Source step of each query or edit the M code in Advanced Editor. 6 Ways to Change Data Source in Power BI - Power Tech Tips
Save and Refresh the Dataflow: After changing the source connection, save your changes and initiate a refresh of the dataflow to ensure that it is now pulling data from the correct source in the QA environment.
Please note, if your data sources require specific credentials or if you're using gateways for on-premises data, ensure that these are correctly configured in the QA environment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @KethanVM
Here's a concise action plan to help you change the source connection of a dataflow from a table in Dev to a table in QA:
Open the Dataflow in the QA Environment: Navigate to the Power Apps solution in your QA environment where the dataflow is located.
Edit the Dataflow: Select the dataflow you wish to modify. Look for an option to edit or configure the dataflow. This will open the dataflow editor.
Change the Source Connection: In the dataflow editor, locate the source connection settings. You will need to update the connection settings to point to the table in the QA environment instead of the Dev environment. This might involve selecting a new data source and providing the connection settings for the QA environment. Then use the new data source's connection information to replace the old queries' data source information. You can modify the Source step of each query or edit the M code in Advanced Editor. 6 Ways to Change Data Source in Power BI - Power Tech Tips
Save and Refresh the Dataflow: After changing the source connection, save your changes and initiate a refresh of the dataflow to ensure that it is now pulling data from the correct source in the QA environment.
Please note, if your data sources require specific credentials or if you're using gateways for on-premises data, ensure that these are correctly configured in the QA environment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Do we need to publish the dataflow after changing the connections?
Yes, you need to publish it. It will trigger a refresh then.