Dataflows Multiple Errors

mohamedmutter · ‎10-18-2021

In Power BI Desktop I'm having two separate issues with dataflows, and I think this may be on Microsoft's end.

1. When attempting to refresh a report that contains a mix of dataflows and other sources that was previously functioning, I am receiving the error "The key didn't match any rows in the table". The only keys that are linking in these tables are date fields. I've gone into the dataflows in the service, and not receiving any errors on that end. I've seen a couple of references on the forum to this being related to excel sheets and the renaming of tabs. I only have a single google sheet as a data source on here and it's not in a dataflow. I've gone through and checked everything to be sure naming conventions have remained the same.

2. When using Power BI Desktop and selecting "Get Data" and choose "Power BI Dataflows" none of my dataflows can be viewed. I have roughly 4 different dataflows with about 8 tables in them and none of them can be accessed.

I've tried uninstalling / reinstalling Power BI to no avail and browsed the community forum and can't quite find any thread dealing with this exact set of issues. Is anyone else experience this? Is it possible it's a service issue.

mohamedmutter · ‎10-21-2021

I ended up submitting a ticket with Microsoft, and they had me reinstall Power BI through the Power BI website itself, rather than using the microsoft store. I then had to go into Transform Data drop down arrow --> Data source settings and re enter my credentials for the data flows. The problem then resolved itself.

Anonymous · ‎10-20-2021

Hi @mohamedmutter ,

Please refer to the following steps to see if it helps you.

1、Please check your flow to see if you have some configuration wrong in the flow

Additionally, there is a similar thread disscussing about this issue and many users get their issues sloved with the help of it.

Please read and check for your scenario.

https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-...

2、Would you please share a screenshot about "I've gone to 'Get Data' to see all Dataflows and there's nothing showing up despite having been able to see options previously "?

Please go to Data Source settings, check if you used dataflow data source previously, if it is, please clear the permission, then back to click on Get Data -> Power BI dataflows, sign in with a Power BI account which has created dataflows before, then check if dataflow listed in navigate pane.

Best Regards

Community Support Team _ polly

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

mohamedmutter · ‎10-19-2021

As one additional note, the only keys that are present in these data flows are dates. I've tried changing them to date times, removing them altogether and removing the google sheets from my data models. I still get the same errors eachc time.