Forum Discussion
Power BI Service gives different errors everytime I attempt to refresh online
Hello,
I've been trying to refresh online but Power BI does not tell me what the exact issue is but instead gives different error messages each time, pointing to different tables.
The most common one is The key didn't match any rows in the table. but a different table each time. No changes to the model are done after each refresh attempt. Sometimes it would say that a particular column does not exist when it actually does. Other times, a cyclic reference error but I have checked for query dependencies and there is no cyclic reference.
There are no error messages when refreshing using PBI Desktop.
My data is sourced from a Dataflow which connects to an azure blob and then an external data from an Excel file in OneDrive.
13 Replies
- GilbertQ
Super User
Hi there
Have you configured your Gateway to use both on-prem and cloud data sources?Thanks for the response.
Mmm. Good question. The dataflow (which queries Azure blobs) is actually managed by a third-party vendor. I am not sure if the case is as you mentioned as the refresh worked fine until, probably, I started bringing in data from OneDrive so I will:- download the original model
- add a dummy external data
- load it to the model
- not do anything else
- upload the newly modified model
- then refresh online
- and i'll see from there.
- GilbertQThat sounds like a good starting point to see if that will work.
It is difficult when there is a 3rd party vendor involved.
