Forum Discussion

DonHoog's avatar
DonHoog
Icon for Advocate I rankAdvocate I
4 years ago
Solved

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

Hi,   I took over some dataflows from a colleague but I cant figure out what the problem is. Here is what I know:   There is a PBIX file with some tabs. When I click refresh in Power BI desktop ...
dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I found a solution for my issue:

    I had to recreate a new dataflow, with the same tables so that was easy

    After that, refresh the sources in PowerQuerry in my pbix file for each tables

    And finaly, upload the pbix in Power Service, so that the dataset can switch on the new dataflow

     

    Hope it can help you too

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I found a solution for my issue:

I had to recreate a new dataflow, with the same tables so that was easy

After that, refresh the sources in PowerQuerry in my pbix file for each tables

And finaly, upload the pbix in Power Service, so that the dataset can switch on the new dataflow

 

Hope it can help you too

DonHoog's avatar
DonHoog
Icon for Advocate I rankAdvocate I
4 years ago

I have also come to a solution, although I dont understand why exactly.

In the post below I explain that I updated the credentials. 

Apparently that worked because I have no errors anymore for 2 days in a row now.

I guess I needed to wait for some time before the Power BI service understood the changes.

 

I am glad it is now fixed for us both but maybe the Power BI service people can try to minimize these bugs in the future. 😉