Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query Append fails when using enterprise gateway to SAP BW

Hello,   I have two queries that pull data from SAP BW via an enterprise data gateway. I then combine them into one table using TABLE.COMBINE() in M.   This works fine in the desktop, but when I ...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Anonymous ,

As mentioned in the "Planning a Power BI Enterprise Deployment" whitepaper:

"

There are limitations within the On-Premises Data Gateway that prevent certain types of complex M queries (used to load data into Power BI) from running successfully, even if these M queries succeed when the dataset is refreshed within Power BI Desktop. Scenarios where this happens include combining data from online and on-premises data sources, and using M functions to make multiple calls to web services.

"

Maybe you can try to use the personal gateway, the following two posts also discuss similar issues, you can see if it helps:

https://community.powerbi.com/t5/Service/Can-t-refresh-data-after-appending-queries-which-are-from/td-p/278598

https://community.powerbi.com/t5/Service/Combining-tables-causing-refresh-to-fail-in-Power-BI-Service/td-p/210137

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Team,

     

    To reduce the black box effects, I pulled the data in separate queries and then combined them with a DAX - UNION statement.

     

    Would have been nice to use M for all of it, but I had to get a solution in place.

     

    Thanks,

     

    Jim