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.
Hi everyone,
My report is almost complete but I still have a question :
I would like to display the date of recording (from my database (Oracle), once a month).
Is it possible to make a parameter or something ?
And the same for the loading of my Excel files, I tried but I can't do it.
If someone could give me some ideas ?
Thanks by advance,
Have a nice day !!
Solved! Go to Solution.
go to Get data --> Blank Query
Goto Advanced Editor
Delete everything in there and replace it with this:
let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source
This will give you a date and time everytime the report refreshes
go to Get data --> Blank Query
Goto Advanced Editor
Delete everything in there and replace it with this:
let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source
This will give you a date and time everytime the report refreshes
Hi ! Thanks so much @Anonymous !
It's working
but I don't know how to put it on my report
it's blank even if i've got the right information in my data
Thanks by advance,
Have a nice day !
Ok, I just find the solution, I created a new measure
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 |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |