Date format issue between PowerBI Desktop and semantic model built on lakehouse sql endpoint

Hi wilson_smyth ,

Thanks for the reply from lbendlin .

If you are storing date data in Lakehouse using the varchar type instead of the datetime type, this may cause you to encounter data conversion errors in Power BI.

Please check if the date columns in the dimDate table are stored as datetime data type, if they are stored as varchar, you need to convert them to datetime.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!