Forum Discussion
direct query dashboard , report,dataset not refreshing
Hi Lydia,
We updated our Power BI Desktop to that version and tried to republish the report. After republishing, we pinned 1 graph to a new dashboard and tried to refresh manually. It still did not refresh.
Out of curiosity, we tried to create another graph on the dataset in the powerbi service (not sure what the difference is) and tried to refresh also from there, but to no avail .
When we refresh from the desktop, it has no problem updating the graph.
I am starting to think though that maybe it may not be refreshing because of the codes we used in the advance editor in edit queries in the powerbi desktop. If you remember my previous help topics regarding the date.time.localnow(), i think these are dependent on the local time of the desktop and I have been reading about the time used in powerbi service is in UTC.
Do you think that would be an issue?
cheskafausto,
Based on my test, adding custom step in Power BI Desktop doesn't impact the refresh in Power BI Service. Do you use the latest version of gateway in your machine?
Regards,
Lydia
Hi,
Apologies for the delay in my reply.
I have just update to the latest on-premises data gateway which is 14.16.6549.2.
I tried first to manually refresh the dashboard, but to no avail, but upon refreshing on the desktop, it did update on the graphic.
I tried waiting for the scheduled refresh. Although the refresh history would state that the refresh is complete, the graphic does not reflect the lastest data.
Please advise.
cheskafausto,
I would recommend you delete the dataset in Power BI Service and re-publish the PBIX file.
Regards,
Lydia