Forum Discussion

kgarron's avatar
kgarron
New Member
10 years ago

Cannot see my gateway from Get Data

Bear with me, I am new to this forum, and new to Power BI and I am an end user, not a developer   1) Installed the Gateway Enterprise on our SQL Server 2) Shows setup was successful 3) Setup a ga...
Need Help
wonga's avatar
wonga
Continued Contributor
10 years ago

Hey kgarron,

 

The gateway acts as the middleman between the Power BI service and on-premises data sources when attempting to do a data refresh. It has nothing to do wtih getting data into a Power BI model initially. That is mostly done through the Power BI Desktop application.

 

General workflow when it comes to using a gateway:

 

1) Use PBI Desktop to connect to a data source(s) whether they be on-prem, online, cloud, etc.

2) Make data model in Power BI Desktop, create reports, etc.

3) Publish report to Power BI Service

4) Configure dataset refresh if needed and there it will ask for a gateway

 

What you see under "Get Data" in the Power BI Service is what's available from a cloud only perspective (i.e. Azure services for now). Any other data source you want to connect to, especially if it's on-premises must be done using Power BI Desktop, and then the subsequent data refreshes are done using the gateway.

 

Hope this helps, thanks.

kgarron's avatar
kgarron
New Member
10 years ago

ah, I did not realize that.  I will try and create something in the Desktop application and publish it. I appreaciate the input.

  • dimazaid's avatar
    dimazaid
    Microsoft Employee
    10 years ago

    The only report you can create via the online "Get Data" thru the Gateway is using Analysis Services.