The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
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 |
---|---|
52 | |
42 | |
23 | |
22 | |
18 |