Query Append fails when using enterprise gateway to SAP BW

[Anonymous]

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 publish to the service it fails every time. 

Is there a setting on the gateway that is preventing the combination of the data (much like in a DATAFLOW?)

Any ideas are much appreciated -- spent all day on this.

Jim

[v-joesh-msft · Accepted solution]

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]

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