Failed Scheduled refresh for Dataflow in Power BI Service

[Anonymous]

Hello Everyone,

I have scheduled Refresh for my dataflow. About Dataflow - Excel attachment come in email. so extracting excel attachment from email through dataflow.  When i do it manually it works. But refresh is failing everytime with error as :

Expression.Error: The key didn't match any rows in the table.

I have no clue what I am looking at . I tried many things . Please help.

[v-yalanwu-msft]

Hi， @Anonymous；

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

1.First started with dataflow. refresh the dataflow.
2. Then  create a report using only dataflow.
3. Checked the gateway connections.

4.Re-enter the datasource credentials which may be fix the error. 

https://dataap.org/blog/2020/05/04/solved-power-bi-dataset-refresh-error-the-key-didnt-match-any-rows-in-the-table/

https://community.powerbi.com/t5/Service/The-key-didn-t-match-any-rows-PowerBI-Dataflow/m-p/1300038#M105919

https://community.powerbi.com/t5/Service/Dataset-refresh-with-DataFlow-Processing-error-The-key-didn-t/m-p/1915189#M131753

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

"When i do it manually it works"

Please elaborate.  Are you referring to Power Query in a Power BI Desktop ?