Data Gateway in Online Power BI

[gabrielhausegge]

Hey all!

I have installed the on-premisis data gateway on my SQL-Server, and also logged in to my power bi account.

In my online Power Bi i can see the gateway, it works.

I have linked a sql database (databasename, user pwd, server) and the connection is also available.

Now i tried to add a dataset but i can't find the sql-data. (I tried under the point (SQL Server Analysis Services).

It tells me "No Resources found"

Can anyone help me?

Thanks a lot.

[ankitpatira · Accepted solution]

@gabrielhausegge Once you've data gateway setup and ready, you should use power bi desktop to connect to your data source, build reports and then publish to power bi service. Once published to power bi service then you have to configure your gateway and add that datasource (that is used in power bi report). 

[wonga · Accepted solution]

@gabrielhausegge

There is certain distinction for connecting to SQL data sources. Are you connecting to an on-premises SQL Server or an on-premises SQL Server Analysis Services instance? 

Also the connection method varies as well. Is it a live, DirectQuery or static (import) connection?

Based on your original post, it sounds like you are connecting to an on-premises SQL Server which can only be done in Power BI Desktop as @ankitpatira mentioned.

If you have an on-premise SQL Server Analysis Server instance that you can connect to, then the connector through the Power BI Service should be usable. Regardless though, Power BI Desktop should be used for all your development needs as that is the platform with most if not all the features.

[ankitpatira · Accepted solution]

@gabrielhausegge Once you've data gateway setup and ready, you should use power bi desktop to connect to your data source, build reports and then publish to power bi service. Once published to power bi service then you have to configure your gateway and add that datasource (that is used in power bi report).