How to enable Automatic dashboard tile and metric refresh in power bi service

[VijayatRuiz]

We have 2 reports published to power service. One report has Automatic dashboard tile and metric refresh option enable and other report doesn't have this option. Both reports are in Direct query mode and we need this option enabled for all the reports. Need your help in this. 

First report setting screenshot

Second Report settings screenshot

[Anonymous · Accepted solution]

Hi @VijayatRuiz ,

Is your dataset a composite dataset that combines an import schema and a DirectQuery schema?
Automatic dashboard tile and metric refreshes are only available for datasets in DirectQuery or Live Connect mode. Datasets in import mode and composite datasets do not require a separate tile refresh as the tiles are automatically refreshed during the next scheduled data refresh.

Refer them : Data refresh in Power BI - Power BI | Microsoft Learn

Troubleshooting tile errors - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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