Dataset not refreshing (from Dataflows)

[Anonymous]

This is very frustrating, I have the same exact issue as:

Re: Dataset refresh from Data flows - Microsoft Power BI Community

The "Data source error: The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: XXX" 

(The table name (XXX) varies from one attempt to the next)

All tables in the data set are from 2 different Dataflows in a different workspace.

I can't get the Dataset to refresh from Dataflows... Also the other post is from February and I don't see a solutoin there either. What's the fix for this?

[brunovarela]

What I did was:

• Change the source from dataflow to Common Data Service
• In the credentials I chose “Private”.

[v-easonf-msft]

Hi, @Anonymous 

I can't reproduce this issue on my side.

After searching for a while, I saw a solution about re-entering credentials. Someone recommends to re-enter the certificate before each refresh.I am not sure if it will work for you.

I would suggest you to create a support tickect to let engineers look into the issue on your side.

They have dealt with many similar problems and they will definitely be able to provide you with more useful suggestions.

Best Regards,
Community Support Team _ Eason

[aj1973]

You must have access permission to the dataflows