Forum Discussion

Annemie19's avatar
Annemie19
Icon for Helper II rankHelper II
5 years ago
Solved

POwe Bi Report Builder - Date/time Conversion failed

Hi There,    I'm starting to use Power Bi report builder. When I try to view my report I keep on getting the error below.     My query is shown below. As soon as I replace the @ProjEndDate...
Need Help
  • Annemie19's avatar
    Annemie19
    5 years ago

    amitchandak  - I found the problem. My parameter data type was set to text and not date/time

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Annemie19 , any reason you are converting dates to text? bring them directly

Annemie19's avatar
Annemie19
Icon for Helper II rankHelper II
5 years ago

amitchandak  - Are you referring to the CONVERT( date,... it just added this before because I thought that it might be the problem. But even without the CONVERT( date,.. it still gives the same error.