Forum Discussion
Add refresh date from Microsoft Dynamics data
Hello How can I add the refresh date into my dashboard if my data comes directly from Microsoft Dynamics? I usually go to Transform Data/ add new / and generate the date from there but in this p...
My problem is that in this report the data comes from Microsoft Dyanamics and hence I cannot access Power Query. Do you have any suggestions in how I could be able to add power query in this case? Many thanks indeed for your time!!!
Can you create one more table in Microsoft Dynamics where in you can store the UTC Now time.
If yes, fetch that table too in Power BI along with all your existing tables.
So what will happen is while your Power BI Report is refreshed then all the tables including the table storing the UTC Now time will be refreshed and plot the visual from that table.
Thank you.
If my solution helps you, please mark it as solution.