Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Processing Error: The key didn't match any rows in the table.

I created a PowerBI desktop file and uploaded to the online service at app.powerbi.com.  The desktop file refreshes just fine, but once it is published to the online service any refreshes fail with: ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

Could you please create a single report that only contains ticket_fields and data of other missing tables, then publish report to Power BI Service and check if you can refresh this report in Service?

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous

 

Yes, I did that.  I narrowed it down to one table that could not refresh.  It could not refresh because the ticket_fields "Key" was not in result from the base Zendesk connector at:

= Zendesk.Tables("https://company.zendesk.com")

The list of tables returned by this command on the desktop is larger than those in the online service.  In particular, "ticket_fields" is missing (among others).  That list of tables is indexed by a key column, which is "ticket_fields".

 

We also asked for support fom Zendesk, however they said that this connector is a Microsoft product and could not do anything about it.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous,

    I would recommend you open a support ticket on the support.powerbi.com site.

    Regards,