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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Atlsql
Frequent Visitor

Error Refreshing Dataset

Good Morning - I have a dataset that is failing to refresh in the Service with the error:

Cancellation occurred when sending or receiving a request.

 

This dataset is processing through a data gateway.  When I check the Gateway for errors, I find:

InnerType=MashupValueException
InnerMessage=<pi>The key didn't match any rows in the table.</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): The key didn't match any rows in the table.

 

When looking at the Desktop file, I cannot locate any errors in the dataset.  Each table and step seems to resolve correctly in preview without issues. 


Anyone have any other ideas?

2 REPLIES 2
Greg_Deckler
Super User
Super User

Can you refresh the dataset from the Desktop? You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg,

 

Yes refresh without issues in Desktop.

 

I did open a ticket - was just looking for other ideas on where to look while I was waiting for Support to get back to me.   I'll take a look at the other thread.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors