Forum Discussion
Solved
Data Source Error: Resource name and Location need to match. Resource name: Query1. Location:x
I build in Power BI Desktop and then Publish. I scheduled a refresh, but when i manually refresh data, it gives the above error.
can you try this:
- delete your dataset from the service
- open the desktop file and hit Refresh (5th icon in the Home ribbon)
- Use GetData from the service to publish the desktop model again (I still don't trust the Publish feature from the Desktop)
- Go to Schedule Refresh->Manage Datasources and enter credentials for all your connections
- try Refresh Now and see what happens
Greg_Deckler
Community Champion
Community ChampionWhat kind of data source?
I pull from a MySQL database. I have about five reports and this is the only one that is having this issue.
- andre
Memorable Member
can you try this:
- delete your dataset from the service
- open the desktop file and hit Refresh (5th icon in the Home ribbon)
- Use GetData from the service to publish the desktop model again (I still don't trust the Publish feature from the Desktop)
- Go to Schedule Refresh->Manage Datasources and enter credentials for all your connections
- try Refresh Now and see what happens
guibenassiAdvocate II
This procedure didn´t work for me.
Neither worked for me.
I have a SharePoint.Files source.
The problem is caused by the "Detect data changes" option. If you (can) disable it, then the error vanishes.
It's a bug ""documented"" in :
https://community.powerbi.com/t5/Issues/BUG-Incremental-Refresh-Fails-Resource-name-and-Location-need-to/idi-p/953828
Thanks Andre! That worked like a charm.
- andre
No worries, glad I could help...
