refresh causes error

[betterreportsDK]

Hi

I get this error when I refresh my data - both manual and automatic - i did not notice in the desktop since there was no error when refreshing. Any ideas on what to do?

[betterreportsDK]

I found the solution myself and eliminated the need for a gateway - and there were two problems:

1) I had two excelfiles updating to my onedrive, which were acutally set not to update but the service saw them as local files and required a gateway. Getting the files through sharepoint instead solved the issue. 

2) The way the web contents function was setup - it has to be adjusted in accordance with this link

[Anonymous]

Hi @betterreportsDK ,

According to the error message "Could data source setting is not allowed refresh through gateway", please try to check the optins in your gateway in Power BI Service Portal.

For more details, you could read related document: Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.