Power says that I have a missing column when I want to refresh but it is not the case

[Anonymous]

hi !

I have a published dashboard with a daily refresh. Everything was fine but since a few days, it doen't not want to refresh anymore.

When I try to repoen the .pbix file and try to manually refresh, I still have the error saying that my "date" column does not exist. But it does not seem to be the case, I can see the date column in my source (Google Big Query with import) and in my fields list in the PBI interface.

Do you have an idea ?

Thanks 🙂

[amitchandak]

@Anonymous , You should open power query for this and check for any issue like date column of data type and try to correct that step and publish again

[Anonymous]

Thanks ! But I see no error in Power Query...

[v-kkf-msft]

Hi @Anonymous ,

Could you please refresh it successfully in Desktop?

Try downloading this PBIX file from Power BI Service, then open it using Desktop and see if the same error exists.

Best Regards,
Winniz