Forum Discussion

DIACHROMA's avatar
DIACHROMA
Helper II
5 years ago

Dataflow table missing in Power BI Desktop

Hi everyone, 

 

I've created a Power BI Dataset connected to several Dataflow tables. Suddently the refresh of this dataset doesn't work anymore. 

I have the below error message : 

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

 

After checking in Power BI Desktop I discovered that there was one table missing from the Dataflow. 

The Dataflow refresh works well. Is just in Power BI Desktop, when I go to Get Data > Dataflow, I see the right workspace, I click on the Dataflow name, I see some tables, but one of them is missing and I don't understand why. 

 

Do you have any clue about what is going wrong ? 

 

Thanks in advance for your help,

Pauline

Dataflow
Need Help

13 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey DIACHROMA ,

     

    can you go to the dataflow itself and check if the table exists in there?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • DIACHROMA's avatar
      DIACHROMA
      Helper II
      5 years ago

      Hi selimovd , 

       

      Thank you very much for your quick reply 😊

       

      Yes, in the dataflow the table exists and the loading is enabled. 

       

      Pauline

      • selimovd's avatar
        selimovd
        Most Valuable Professional
        5 years ago

        DIACHROMA  that's strange. And when you open Power BI Desktop and connect to that data flow the table doesn't appear, right?

        The load of the table is enabled, right? Right click on the table and "enable load" is activated?

         

        If you need any help please let me know.
        If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
         
        Best regards
        Denis
         
  • njwilliams's avatar
    njwilliams
    Regular Visitor
    5 years ago

    Hi, selimovd -

     

    I have what seems to be a similar issue.

    • Dataflow connects to 7 CDS/Dataverse tables
    • 5 tables are showing in power bi desktop while 2 are not
    • Dataflow is scheduled to refresh and logs show all 7 tables refreshing
    • 2 tables with missing content are nearly identical queries to other 5 and all 7 show data when viewing online.

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      njwilliams That sounds like a bug for me. I would create a ticket, I think it makes sense that MS is taking a look why this is happening.

      Best regards

      Denis

      • njwilliams's avatar
        njwilliams
        Regular Visitor
        5 years ago

        Thanks for the reply. Helps to feel like I shouldn't keep chasing a fix on my own.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    Hi DIACHROMA ,

     

    Pop over to this thread. See if it will help you workaround this problem.

     

    Solved: Just started this week - DATAFLOW table does not show up in Power BI desktop 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • DIACHROMA's avatar
      DIACHROMA
      Helper II
      5 years ago

      Hi v-kkf-msft , 

       

      Thanks for the reply. I check your link but in my table I don't have any date 😞

      Anyway I think it's a bug so I made differently in Power Query without using Dataflow...

       

      Thanks again for your help !

      Pauline

  • aneesvvm's avatar
    aneesvvm
    Frequent Visitor
    3 years ago

    Have you got any solution for this issue? I also face the same issue