cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martin93
Frequent Visitor

Troubles with refresh in Power BI Service - The key didn't match any rows in the table.

Hello,

 

I would like to ask you for a help with my Power BI Service refresh issues. I have a dataset which consists of 18 tables (16 from Oracle database and 2 sharepoint files) and I am able to refresh it on the desktop version without any problem. The troubles start when I publish it into the Power BI Service where I am not able to refresh it because I get the underlying error message "The key didn't match any rows in the table." When I try to republish the dataset then a second table threw the same error.  It is a domino effect because all tables are failing one at a time. The tables, however, are fine.  I have checked in Power Query, that my queries are right without any orange triangles.

What has come to my mind is that it could be related to Gateway Settings because I am working for a different department and this project is published into a different workspace than the previous one which was working well but the gateway settings are still the same. Or maybe it can be caused by the mix of two data sources Oracle database and sharepoint. But I am just guessing.

Thank you in advance for your help,

Martin

1 REPLY 1
arvindsingh802
Super User
Super User

Please make sure, you are using same or same access level credentails in Power BI Desktop and in gateway datasource


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors