Power BI Service gives different errors everytime I attempt to refresh online

[Anonymous]

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. 

[GilbertQ]

Hi there

Have you configured your Gateway to use both on-prem and cloud data sources?

[Anonymous]

@GilbertQ,

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. 

[GilbertQ]

That sounds like a good starting point to see if that will work.

It is difficult when there is a 3rd party vendor involved.

[Anonymous]

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>

[GilbertQ]

Hi 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?

[Anonymous]

Can you elaborate please?

[GilbertQ]

Hi there

When you create Parameters in your PBIX file, you can then also change the parameters in the Power BI Service?

[Anonymous]

Yes, I can.

[Anonymous]

---

@GilbertQ wrote:
Hi there

When you create Parameters in your PBIX file, you can then also change the parameters in the Power BI Service?

---

Hello,

The data model is parameterised but I do not think it is the cause. I created a basic and simple dataset (no measueres, calculated columns or additional transofrmations) connected to a table in dataflow, uploaded it and then attempted to refresh it. I would still get the same "The key didn't match any rows in the table. Table:" error. 

[GilbertQ]

Hi there

I am not sure then what the cause is.

I would suggest opening a support ticket with Microsoft to troubleshoot

https://powerbi.microsoft.com/en-us/support/pro/

[Anonymous]

Unfortunately, I won't be in pro until my trial expires. 😞

[GilbertQ]

Hi there,

You could get your trial upgraded to pro before it expires, which will then allow you to log a ticket?

[Anonymous]

@GilbertQ 

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.