Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to Create Date Parameters in Direct query

Hi Team,   I'm want to restrict the data to the users. So, i have created a Date parameter wherein user have to select Start date and End Date in Power bi service.    I have created below M Langa...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Jayendran,

     

    Thank you for your reply on this...

     

    I Have created parameters as showed in your video it is working in Power Bi desktop. However, when i go to Dataset  -- Settings -- Parameters. Over there in StartDate and EndDate i have give date range. As per the given date range data is not populating in power bi service. My i know the reason... In Desktop it is working fine but when comes to PBI Services why data is not populating as per given range....

     

    Please clarify..

     

    Thanks in adavance.

    RAVIP

  • FarmerKenny's avatar
    FarmerKenny
    Helper II
    3 years ago

    I passed the exact syntax to my SQL query for the data parameter, '"StartTime"' and I received a token Comma  syntax error in the Advanced Editor.  Both the Parameters are Date data types.  Any ideas?