Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataset not refreshing (from Dataflows)

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?
Dataflow
Need Help

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    You must have access permission to the dataflows

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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

  • brunovarela's avatar
    brunovarela
    Helper I
    5 years ago

    What I did was:

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