Forum Discussion

betterreportsDK's avatar
betterreportsDK
Helper I
2 years ago

refresh causes error

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?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • betterreportsDK's avatar
    betterreportsDK
    Helper I
    2 years ago

    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