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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)