Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Dataset Refresh Error:

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:

 
 
 

c.PNG

 

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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

5 REPLIES 5
v-lid-msft
Community Support
Community Support

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,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GilbertQ
Super User
Super User

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

And what happens if you add it back in?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

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

Thanks for letting us know!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

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? 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors