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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
GiantRectangle
Regular Visitor

Data Source Error Blocking Refresh in Web Service

I've got a view in snowflake and I've successfully connected to it in PBI desktop. Everything works fine to that point.
However, once loaded to the web service, refresh fails with this message:

Data source errorExpression.Error: The key didn't match any rows in the table.. Key = <ccon>[Name = "PROD_PUBLISH", Kind = "Database"]. Table = #table({"Name", "Description", "Data", "Kind"}, {}). </ccon>;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: RPT_LABOR_DETAIL.

I tested it as the sole data source added to a fresh file with no transformations, and I get the same error.

I then performed the same test with another view within the same snowflkke database and schema and got the same problem.

I then tested a view from a different database (dev_publish.public.timeframes) within the same environment, and it also failed.

However, the original dashboard using the connection to dev_publish.public.timeframes has been refreshing daily just fine


Can anyone suggest what I might be doing worng?

1 ACCEPTED SOLUTION
GiantRectangle
Regular Visitor

yeah, it was getting all the data in the desktop file, but then wouldn't refresh in the web service. so it was fine to start, but I couldn't schedule refresh.

anyways, it turns out to have been a credentials issue. we've got snowflake locked down to only accept a service accout user from the ips used by the web service.

given that this was the case, I don't understand the error I got initially.

(shrug)

View solution in original post

2 REPLIES 2
GiantRectangle
Regular Visitor

yeah, it was getting all the data in the desktop file, but then wouldn't refresh in the web service. so it was fine to start, but I couldn't schedule refresh.

anyways, it turns out to have been a credentials issue. we've got snowflake locked down to only accept a service accout user from the ips used by the web service.

given that this was the case, I don't understand the error I got initially.

(shrug)

GilbertQ
Super User
Super User

Hi @GiantRectangle 

 

From what you have said it sounds like it is an issue where the data being returned is not expected.

 

What happens if you create a PBI Desktop file with just this table, refresh it in the Power BI Service and see if it gets all the data?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.