Forum Discussion

TomRobbins's avatar
TomRobbins
Frequent Visitor
3 years ago

Problem publishing after changing data source from local folder to SharePoint folder

Built tons of things in PBI Desktop all using local Folder combinations of files as data source. We assumed since these were OneDrive synced folders that we could easily publish to the Pro service wh...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , TomRobbins 

All data sources in your dataset should still include local data sources. Yes, currently on Power BI Service, all data sources need to be configured with the correct credentials for scheduled refresh.

If you don't want to use a gateway, you can completely delete all on-premises data sources and republish them so you don't need to use a gateway.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

TomRobbins's avatar
TomRobbins
Frequent Visitor
3 years ago

Yea, that's the problem.  All of the reports were built pointing local drive that is synced via OneDrive.  That was our mistake.  We thought it would be smart enough to know it was a OneDrive location. 


Opened a ticket with Microsoft because there should be a way to have the original data source settings match what is in the M code.   Right now the original data source settings points to local folder path but the M code uses a SharePoint path and that works great.  But in publish the service ignores what the code does and looks at any original settings you configured.