Forum Discussion

FODK's avatar
FODK
New Member
1 year ago
Solved

Gateway Data MashUp error

Hi, I am dealing with the following problem with 3 of the reports I run (out of +-90): We are using an on-prem SQL server and this (and the other two problem giving reports) have an excel fil...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi FODK

     

    It usually happens when you're combining an on-prem SQL Server with something like a SharePoint Online Excel file. Power BI Gateway struggles with that mix (called a hybrid data source).

     

    Here are some steps :

    • Make sure your SharePoint connection is using OAuth2, not Windows or Anonymous.

    • If possible, avoid combining cloud + on-prem data sources in the same report the gateway often can't handle it well.

    • If moving the SQL data to Azure SQL is an option, that usually resolves the issue.

    • Alternatively, using Power BI Dataflows to prep one of the sources separately might help too.

    Since it works in Desktop but fails on Service, it's almost certainly a gateway-related problem not firewall or credentials.

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi FODK

 

It usually happens when you're combining an on-prem SQL Server with something like a SharePoint Online Excel file. Power BI Gateway struggles with that mix (called a hybrid data source).

 

Here are some steps :

  • Make sure your SharePoint connection is using OAuth2, not Windows or Anonymous.

  • If possible, avoid combining cloud + on-prem data sources in the same report the gateway often can't handle it well.

  • If moving the SQL data to Azure SQL is an option, that usually resolves the issue.

  • Alternatively, using Power BI Dataflows to prep one of the sources separately might help too.

Since it works in Desktop but fails on Service, it's almost certainly a gateway-related problem not firewall or credentials.