Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
fullthrottle
New Member

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.

Dashboard_Error.png

1 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

 

View solution in original post

9 REPLIES 9
Greg_Deckler
Super User
Super User

What kind of data source?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

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

 

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

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

Nor me. Its happened since I sent up Incremental Processing

Thanks Andre! That worked like a charm. 

No worries, glad I could help...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors