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 everyone. I'm looking to setup a Power BI dashboard in the cloud with on-prem tabular model SSAS cubes as the data source. My understanding is this is possible using an Azure Analysis Services on-premises data gateway configured in Azure with an on-premises data gateway setup and registered. While setting up a mockup of this environment in DEV I ran into a challenge.
1. How does one get the Cloud SSAS instance talking to the on-prem tabular models?
1a. Can I simply use Power BI Desktop to open the on-prem tabular models then publish the PBIX to SSAS in Azure and Poof! it just works?
2. Or do I take the on-prem tabular models I already have and publish those to Azure Analysis Services and the refresh will go through the data gateway to on-prem SQL Server?
I created the sample AdventureWorks model in Azure Analysis Services and I see that I can open it in Power BI Desktop. It doesn't seem to get data from anywhere, however. I'm still working my way through all the Microsoft Docs. Not afraid of reading if you know where to point me.
Thanks for taking the time to read my inquiry!
Solved! Go to Solution.
Beautiful, this is the elegant I solution I was hoping for. And thank you for sending over the link to the SSAS article for the gateway! The whole Azure Analysis Services setup in the Gateway sent me on a tangent when the answer was just sitting in the Power BI Gateway configuration menu. Appreciate the help!
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.