cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Accepted Solutions
Highlighted
Responsive Resident
Responsive Resident

@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

2 REPLIES 2
Highlighted
Responsive Resident
Responsive Resident

@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

Highlighted
Frequent Visitor

@ToddChitt,

 

thanks. Changing DB credentials fixed it 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors