Forum Discussion
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...
Hi Anonymous ,
Basically it should work. Do you have tried this with the latest PBI Desktop ?
Here is the real working sample video : https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI
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