Forum Discussion

SSRWes's avatar
SSRWes
Microsoft Employee
6 years ago

Dataset refresh from Data flows

I'm getting a dataset refresh issue with a customer. Premium capacity. All tables in the data set are from 1 of 3 different Power BI data flows in the same workspace. The data flows are refreshing a...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
6 years ago

We are having the same issue.  Report datasets are failing , but the underlying data flow is refreshing correctly.

 

  • MessageThe key didn't match any rows in the table. Table: FactSales.
  • Cluster URIWABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
  • Activity ID5890037b-73a1-44df-8488-fe2e4fa1fbef
  • Request ID7f2b77a8-e509-4ee6-8ce9-8178ebdb1f32
  • Time2020-02-12 06:34:58Z

The Table name occasionally changes.

 

here is a link to another report of the same issue

https://community.powerbi.com/t5/Service/The-key-didn-t-match-any-rows-in-the-table/m-p/929654

 

  • S4CSurrey's avatar
    S4CSurrey
    Helper I
    6 years ago

    Bump

    • S4CSurrey's avatar
      S4CSurrey
      Helper I
      6 years ago

      Still broken on my end. How's it going for you all?

      • npnigro's avatar
        npnigro
        Advocate III
        6 years ago

        We're having the same issue on multiple tenants. I assumed it was a new capacity constraint but bumping up our Power BI and Azure capacity didn't help. Oddly the refresh works fine on Power BI Desktop. How about everyone else?