Data Source Error: Resource name and Location need to match. Resource name: Query1. Location:x

[fullthrottle]

I build in Power BI Desktop and then Publish. I scheduled a refresh, but when i manually refresh data, it gives the above error.

[Greg_Deckler]

What kind of data source?

[fullthrottle]

I pull from a MySQL database. I have about five reports and this is the only one that is having this issue.

[andre · Accepted solution]

can you try this:

1. delete your dataset from the service
2. open the desktop file and hit Refresh (5th icon in the Home ribbon)
3. Use GetData from the service to publish the desktop model again (I still don't trust the Publish feature from the Desktop)
4. Go to Schedule Refresh->Manage Datasources and enter credentials for all your connections
5. try Refresh Now and see what happens

[guibenassi]

 This procedure didn´t work for me.

[nicolaRaeese]

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-nee...

[DebbieE]

Interesting that its detect data changes. It would seem that Power BI pro isnt quite ready to go with Incremental processing possibly

[DebbieE]

Nor me. Its happened since I sent up Incremental Processing

[fullthrottle]

Thanks Andre! That worked like a charm. 

[andre]

No worries, glad I could help...