Forum Discussion

manoj_0911's avatar
manoj_0911
Icon for Kudo Commander rankKudo Commander
2 years ago
Solved

Exploring Data Source Replacement Techniques in Power BI

Hello Power BI Community,

 

I'm currently seeking guidance on how to effectively replace data sources within Power BI. As we continue to refine and optimize our data workflows, the ability to seamlessly transition between different data sources is paramount.

 

Could you please share your insights, tips, and best practices on how to replace data sources in Power BI? Whether it's a straightforward process or involves more intricate steps, any guidance or experiences you can provide would be greatly appreciated.

 

Thank you for your assistance in advancing our data management capabilities within Power BI!

 

Best regards,
Manoj Prabhakar

Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    Hi manoj_0911 ,

     

    To replace a data source in Power BI Desktop, you can follow these steps:
    - Open your Power BI report in Power BI Desktop.
    - Navigate to 'Home' > 'Transform Data' > 'Data source settings'.

    - In the 'Data source settings' window, select the data source you wish to change and click on 'Change Source'.
    - Update the connection details for your new data source and click 'OK'.
    You may need to refresh your tables or queries if the data structure of your new source differs from the original.


    Best Regards,
    Yulia Yan


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Icon for Community Support rankCommunity Support
    2 years ago

    Hi manoj_0911 ,

     

    To replace a data source in Power BI Desktop, you can follow these steps:
    - Open your Power BI report in Power BI Desktop.
    - Navigate to 'Home' > 'Transform Data' > 'Data source settings'.

    - In the 'Data source settings' window, select the data source you wish to change and click on 'Change Source'.
    - Update the connection details for your new data source and click 'OK'.
    You may need to refresh your tables or queries if the data structure of your new source differs from the original.


    Best Regards,
    Yulia Yan


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.