Dataflow table missing in Power BI Desktop

[DIACHROMA]

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

[aneesvvm]

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

[v-kkf-msft]

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]

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

[njwilliams]

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]

@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]

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

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[DIACHROMA]

Hi @selimovd , 

Thank you very much for your quick reply 😊

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

Pauline

[jeffshieldsdev]

Have you tried refreshing the dataflow?

[selimovd]

@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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[DIACHROMA]

@selimovd and @jeffshieldsdev ,

Yes the loading is enabled and the refresh is done correctly (in any case I have no error message).

However I just realized that when I go to the Dataflow on the service, and that I develop the table I have nothing. I don't see the column names like other tables that are working fine.

What is weird is that I have no error in the refresh but I have the impression that the contents of the table are not loading (while it is enabled correctly and I get data in the preview). 

Pauline

[jeffshieldsdev]

I don't see the column names like other tables that are working fine.

That makes me think there's something invalid about the table the query is producing.

What is being returned is a Table and not a List?  Are all your columns properly typed and not using Any data type?

Do you start to see columns and rows as you click up through the Applied Steps in the query?

[selimovd]

Hey @DIACHROMA ,

yes, when the content is not there, there is something wrong with the data flow.

Solve that and the load will be solved.

Try to copy the M-Code from the advanced editor in data flows and paste it in a blank query in Power BI. That usually makes it easier to debug the issue.

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic