Dataset Refresh Error:

[Anonymous]

Hi All, 

I am using a Dataflow i created which has tables from google bigquery and one drive. The schedule refresh on this data set has been working fine for last 3 weeks. Today while refreshing the dataset, it threw me this error:

The error reflected in Desktop as well. I opened "edit queries" and refreshed the preview and realised that the Data flow doesnt have the 3 google big query tables. However, on service I can see all the tables in my dataflow. Kindly help. 

[v-lid-msft]

Hi @Anonymous ,

Does the data flow connect to a excel file? Could you please check if there are anything changed in the data source, such as name of sheet or column? Please also refer to this similar thread which told about the same issue: Expression Error.: The key didn't match any rows in the table

Best regards,

[GilbertQ]

Could it be possible that someone had made a change to the dataflow?

And what happens if you add it back in?

[Anonymous · Accepted solution]

Hey, I found the solution. I changed the dada type of "Date" column to datetime from Date. 

[GilbertQ]

Thanks for letting us know!

[Anonymous]

Hello Maanav,

I encountered this error last Friday as well. The solution was the same (change from Date to DateTime column). Prior to Friday, my dataflow was working normally and there were no column or table changes (source SQL server).

Would Microsoft verify if this is an issue with Power Query in the Power BI Service?