Dataset refresh with DataFlow, Processing error: The key didn't match any rows in the table.

[DVE]

I'm tring to solve the following issue:

For our power users we provide them DataFlow(s) to different sources. To simply this issue, I brougth the example back to just a dataflow to a database service in Microsoft Azure and that also fails in this error.

I performed the followingsteps, each time with a new configuration: 

1. PBIX to Dataflow, using view; 
2. PBIX to Dataflow, using table; 
3. PBIX to Dataflow, using table with marking a key; 
4. PBIX to Azure SQL Service Database directly using view; 
5. PBIX to Azure SQL Service Database directly using table.

Tested the following senario's (numbers correspond with steps above):

Steps i took to configure:

1. Create Dataflow
   1. Provide SQL Statement in Advanced settings
   2. Make sure on-primises gateway is set to none
   3. Authentication type is Microsoft Account
2. Check Dataflow M-Code for exact naming confentions
3. Open power bi client, check and clear all datasource permissions
4. Attach datasouce (Dataflow or Directly)
5. Checked M-Code
6. Published and try refresh

[DVE · Accepted solution]

After several attempts to get a solution from Microsoft support we requested to close the ticked, as we didn't got any answers to our questions. However someone woke up after sending this mail and we got help from a Senior Support Professional. We took him through the scenario and found a solution that was relatively simple.

We needed to change the credentials on the dataset setting in the workspace. Probebly there was something wrong with my account on the Power Bi server, with this re-adjustment it is now fixed.

[v-xiaotang]

Hi @DVE 

I find links helpful, please refer to:

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

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

[DVE]

@v-xiaotang thanks, for you're reply. I allready read these articles and checked this. The DataFlow show data and the Power Bi client is refreshing the data fine locally. Ones I publish and hit refresh the dataset in Power Bi online I get this processing error. 

I also openend a ticket to Microsoft but they are researching the log's and m-code for a week now.

M-Code DataFlow:

M-Code Power Bi (Dataset)

[v-xiaotang]

Hi @DVE 

thanks for your reply. 

Waiting for your information, and could you share the solution after receiving their reply? so that the others having same problem can refer to this post. 👍

Best Regards,

Community Support Team _ Tang

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

[DVE]

I will, although Microsoft support is not replying to my mails or updating me about thier progress. Can someone with MSDN and Power Bi Licence or Trail license try my example and see if the refresh of the dataset fails?