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.
Hi all,
I figured this method out to deploy xmla to powerbi.com and also set the credentials automatically even if your datasource is azure sql or dedicated sql pool Synapse.
I read everywhere that it wasn't possible, but I found a way.
https://jessegorteronazure.wordpress.com/2022/01/20/releasing-power-bi-datamodels-with-xmla/
Let me know if this helps or if you think it should be done differently, afaik this is the only way, but I could be wrong 🙂
Also, is this way even supported, or is this a hack? It seems supported, I am just suprised there is a gatewayid for a azure cloud source.
Hi, @jessegorter
If you know what he's talking about, then you can try it. The method is difficult and I ‘m afraid few people know about this, so do I.
If you can clarify your original needs, maybe we can help you out.
Best Regards,
Community Support Team _ Janey
Hi,
this is especially handy in the case you are migrating your azure analysis services models to Power BI Premium. Or when you are considering automatic deployment from a professional development standpoint. Not for self service reporting needs
Hi, @jessegorter
If you fully understand this method, try it and succeed, you can share the link in the reply below, and then mark your answer as solution, people in need will search for this method more quickly.
Best Regards,
Community Support Team _ Janey
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.