How to automate refresh data in .pbix doc

Thanks for the reply from NandanHegde , please allow me to provide another insight:

Hi, VedranR 
Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

1.Firstly, we recommend uploading your PBIX file to the service for scheduled refresh. This is the most efficient and practical solution provided by the official documentation, and it also facilitates sharing. Here is a screenshot from the relevant documentation:

For further details, please refer to:

Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn
 

2.Lastly, you can consider using third-party software:

For further details, please refer to:

Power Update – Prima Consulting
 

Best Regards,

Leroy Lu

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