Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Just getting started with PowerBi and I want to use the SaaS PowerBi app (not PowerBi Desktop) to create some dashboards against an on-premises SQL Server. I have installed the PowerBi Enteprise Gateway and configured it. It appears to be working properly as when I click 'Test Connection' I get 'good to go'. So the connection from PowerBi to the Gateway to the on-premises SQL Server appears to be working.
What I don't understand is how to access the data behind the gateway. I assume that I need to create a dataset but when I select 'Get Data' there is no option to select the enterprise gateway. What am I missing? Perhaps something very obvious. What do i need to do to create datasets based on the on-premises data?
This just switched over like March 31st, so it may not be working quite correctly just yet, but what you are supposed to do is to create a connection in the Enterprise Gateway to your SSAS cube. Then, you use Get Data | Databases&More | SQL Server Analysis Services and your published connections in your Enterprise Gateway are supposed to show up.
Check out the Add data source section here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/