Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

Last Refresh time data input not working in PowerBI Service?

I have added a query that contains my local date time the query is like this:   = DateTime.LocalNow   and created a table for this and am using that column inside my report, but the problem is wh...
Need Help
Show and Tell
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anmolgan ,

Please try to change the data type to Date/Time in Query Editor.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

v-xuding-msft  mwegener  nahid3152 

 

I had managed to set the refresh time according to my local time, but now the problem is the last refresh time is not able to match with the last refresh time which is shown in my powerbi service refresh history, I thought this is a problem with me creating an additional table, and the main query table not being refreshed so I tried to create a refrence measure inside my same master table, but still the refresh time does not match?

 

Is there any way to solve this?