Forum Discussion
Power BI Service gives different errors everytime I attempt to refresh online
Super UserHave 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.
It seems that my previous assumtion iswrong. I uploaded the original model without doing anything else to it (no editing, etc), published it and attempted to refresh it online but still got an error: The key didn't match any rows in the table. Table: <random table>
- GilbertQHi there
It would appear that possibly there is some difference when the data is refreshed online vs Power BI Desktop?
Is the data identical with no parameters used in the Power BI Service?