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 co...
GilbertQ
Super User
Super UserHi there
Have you configured your Gateway to use both on-prem and cloud data sources?
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.What you've mentioned seems to be the issue. Power BI service returned another "The key didn't match any rows in the table. " but this time it's another table.
I wish the service would just say that the gateway is not enabled to handle both on-prem and online data instead of giving confusing errors.
That aside, I've been under the impression that connections to Azure blobs are supposed to be online and not on-prem but that doesn't seem so, at least, in my case.