Forum Discussion
Solved
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: Da...
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)
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?