Power BI won't auto refresh

[JRTV]

I need help with this please! I have my data set switched to web so that is not the issue. It is still saying I need to enter credentials for data sources. I CANNOT get a gateway as this is for work. I CANNOT clear all permission as this is for work. I tried to set up Power Automate inside of Power BI but it will not refresh the data. Screenshots below.

Error message

Showing data is URL

Saying "Cloud Connection Maps to Personal Cloud Connect (I don't know what this means)

Data source and Refresh greyed out

[v-heq-msft]

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