Last Refresh Date for reports using direct query

[Anonymous]

Hello,

I am using a direct query in my power bi report. Which means edit query or advanced editor is not available.

It is on schedule refresh. I want to show the last refresh date on the report page.

Appreciate all ideas.

Best, Fulya

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

I think you probably mean that there is no advanced editor from Power BI Service.

Based on my test, the editor query and advanced editor can be opened in the report with Direct Query connection from Power BI Desktop.

For showing the last refresh date, please kindly refer to:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

Best Regards,

Stephen Tao

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

[amitchandak]

@Anonymous , Direct Query should as good as last queried?