The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
36 | |
31 | |
23 | |
14 |