Forum Discussion
Solved
Power Query - Date Parameter Binding to my DirectQuery Mode error Converting from #datetime to Date
My data types in the my slicer field and parameter are the same. So, I can bind them. My Power query call a Table Valued Function using the date Parameter. When the Parameter is not bind yet, t...
As other people have said, it looks like a data type mismatch. As the docs say here https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerations-and-limitations you'll need to cast your parameter to a Date in the M code for your Power Query query using the DateTime.Date function.
Opening the error:
As other people have said, it looks like a data type mismatch. As the docs say here https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerations-and-limitations you'll need to cast your parameter to a Date in the M code for your Power Query query using the DateTime.Date function.