Forum Discussion
Change Data Source but Keep Models and Visualizations
]Hello, I am using DirectQuery to get data from SAP business one system and created visualizations for in Power BI. However, we have multiple data warehouses (with the same data structure) (for examp...
Hi Anonymous ,
Agree with lbendlin.
In addition, if you have two identical tables from two different data source, you can append them in the Power Query editor to make one table.
Append queries - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's what Power Query parameters are usually used for. You use them in your source definition, and then you can change the parameter in the Power BI Service (or even in Power BI Desktop) to switch sources "dynamically" (the change will only take effect on the next query or refresh)
Haven't tried this with Direct Query, but that's how it works for Import mode sources.