Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Source Settings

Hey All,   Trying to change my Data Source Setting in BI from a SharePoint connection to a local file. This is proving difficult as I do not see the option to add additional sources or edit the exi...
Need Help
  • ilton's avatar
    ilton
    4 years ago

    Hi Anonymous 

    You can do pretty much anything with your data in the transformation part

    1. Open tranformation editor

    2. Add the local file as a new source

    3. open the advanced editor

     

    4. Replace the source from the sharepoint query with the source from the local file query

    you may need to adjust a few things manually afterwards.

     

     

    Is this helps consider marking it as a solution

    If you need any help let me know

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

Currently the Change Source feature in Power BI Desktop only supports the same data source, if you want to change an SharePoint source to a local file, you may need to do like @ ilton  mentioned.

 

You can also refer this article: How To Change Data Source Of Existing Report In Power BI 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.