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

Refresh failing in online but working in desktop version with out any issue.

Hi ,

 

I am creating a simple drag and drop report on a snowflake DB view without any transformation. Report seems to be working fine and refreshing in desktop version ( import mode) but when i am publishing it online and doing dataset refresh a very cryptic error is coming . Please help.

 

Something went wrong

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

  • Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Name = \"ITAI_DB\", Kind = \"Database\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: AIP_IBSA_CHNG_MNGMT_REPORT_VEW.
1 ACCEPTED SOLUTION
ToddChitt
Solution Sage
Solution Sage

@mpk 

The error statement "Key did't match any rows in the table" usually refers to the fact that the table or source object is missing from the database. 

 

Suppose I have a Data Source connected to an Excel tab. Everything works fine, and I have my Gateway Data Source pointing to that Excel file. I then go in and delete that tab. I will get an error "Key didn't match any rows in the table".

 

Possible causes:

1) the table is actually NOT there anymore, but this doesn't sound likely

2) the user account as specified in the Gateway Data Source does not have permissions to view or see this object. This is more likely. 

 

Tre editing the Gateway Data Source and use the SAME CREDENTIALS you used when setting up the connection in Power BI Desktop. The results, either positive or negative, will tell you something.

 

Good luck. Hope this helps.

View solution in original post

3 REPLIES 3
ToddChitt
Solution Sage
Solution Sage

@mpk 

The error statement "Key did't match any rows in the table" usually refers to the fact that the table or source object is missing from the database. 

 

Suppose I have a Data Source connected to an Excel tab. Everything works fine, and I have my Gateway Data Source pointing to that Excel file. I then go in and delete that tab. I will get an error "Key didn't match any rows in the table".

 

Possible causes:

1) the table is actually NOT there anymore, but this doesn't sound likely

2) the user account as specified in the Gateway Data Source does not have permissions to view or see this object. This is more likely. 

 

Tre editing the Gateway Data Source and use the SAME CREDENTIALS you used when setting up the connection in Power BI Desktop. The results, either positive or negative, will tell you something.

 

Good luck. Hope this helps.

Thanks, this prompted me to find the answer.  We have three Devs and no service account, so using linked dataflows in the service just uses one of our personal accounts.  I didn't realise that someone had changed the connection to their login and that didn't have access to one of the sources (it was a new test workspace).

 

Granted all devs access to the workspace and it worked.

mpk
Frequent Visitor

@ToddChitt,

 

thanks. Changing DB credentials fixed it 🙂

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors