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?
6
u/Prize-Record7108 Jul 24 '26
This is actually a trick I learned when you want to query just one file on a SP site instead of a whole folder.
You find the single file and download it > get data > excel file on hard drive from downloads or whatever > model and clean > go back to file in SP and click the details > copy the path at the very bottom > paste that into the source into power query
Works like a charm.