Power BI won't auto refresh

Hi JRTV ,
According to your description, your data source is fetching in Import mode, even though you are using a web link. If you want to refresh your data on power BI service, as your error message indicates, you need to configure the gateway and data credentials to communicate between cloud and local. If you can't configure a gateway, you can try OneDrive Refrsh, you can put your pbix file into OneDrive and get the pbix file stored in OneDrive in workspace, this will form the communication between the cloud without you having to configure a gateway.
You can learn more about refreshing by checking out the following documentations
Configure scheduled refresh - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Refresh a semantic model from OneDrive or SharePoint Online - Power BI | Microsoft Learn

Best regards,
Albert He

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