Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello,
how to pass system date to parameter ....
#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]
regards
pooja Dhonde
Solved! Go to Solution.
Hi @Anonymous,
You could create a Blank Query by DateTime.LocalNow() in Query Editor to get the system time.
Then you try to use this accessing data funtion below in the Advanced options when you get data from SQL Server Datebase.
Sql.Database(server as text, database as text, [Query = "select A from table where..." & "localtime"]) as table
In Addition, you could have a good reference of DateTime.LocalNow() and Sql.Database.
Best Regards,
Cherry
Is that a statement or a question?
DateTime.LocalNow will give you the "system time"
Hi @Anonymous,
You could create a Blank Query by DateTime.LocalNow() in Query Editor to get the system time.
Then you try to use this accessing data funtion below in the Advanced options when you get data from SQL Server Datebase.
Sql.Database(server as text, database as text, [Query = "select A from table where..." & "localtime"]) as table
In Addition, you could have a good reference of DateTime.LocalNow() and Sql.Database.
Best Regards,
Cherry
Thank you..
Hi @Anonymous,
That' my pleasure.
Best Regards,
Cherry
#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]
hello,
how to pass system date to parameter ....
regards
pooja Dhonde
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |