The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 existing SharePoint connection to a local one. Any help/assistance would be greatly appreciated.
Thank You
Solved! Go to Solution.
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
Hi @EduardoMarino ,
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
21 | |
20 | |
16 | |
13 |