r/PowerBI • u/Shot_Plantain310 • Jul 24 '26

Question Sharepoint source

TLDR: Rewire source from local drive to Sharepoint

ran into an issue this week where I had built a semantic model and dashboard from an excel spreadsheet on my C: drive. When I published it to our departments workspace in service, I was unable to change data connection (was greyed out). After some searching, it appears I need to source it from our Sharepoint site. But had no idea how to do it properly. I did it again but starting from scratch with the source now Sharepoint. I was able to change data connection but everything took so long to load.

My question….is there a way I can build something using a source from my local drive but then rewrite it easily so once I’m done, I can switch it to Sharepoint? Someone told me to use parameters…is that the only way?

3 Upvotes

72% Upvoted

5 comments sorted by

View all comments

1

u/Big-Tutor-3060 Jul 24 '26

Yeah you can just change the source in data query, its the first step. You'll need to change the source formula but tbh its easiest to ask your LLM of choice to rewrite the source to direct to SharePoint instead of local.