Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
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.
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:
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.