Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Schedule refresh - gateway

Hi!   I created a report at PowerBI Desktop (which is working and refreshing data normally) and published (I'm trying to understand better this app, btw).   The problem is that now I want to sche...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,


    Which type of gateway does the DBA install for you, on-premises gateway or personal gateway? 

    If the DBA installs on-premises gateway , he should go to the administrator’s tab of the registered gateway to add you as additional admin, then you will be able to see gateway in "Manage gateway", and you are able  to add all data sources within the gateway.

    Regards,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

Thank you so much for your reply. My question is probably really dumb, and I apologize, but I'm new at Power BI.

 

Yes, I'm using SQL and SharePoint.

 

Here at work I only know that the gateway is installed on a server, and they migrate the database to this server. I got data at PowerBI desktop using my SQL user. That's all I know. I thought that it would appear to me, at the Service, the gateway, because my power BI account is connected to Office 365, with single login. But I was wrong.

 

What should I do for this gateway, that is installed in the server, appears to me?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Depending on your access rights, there is an option in the Power BI Service called "Manage Gateways".  This is where you add in your data sources in the same manner as they appear in your Power BI Desktop file.  If 100% of your data sources match a data source in the "Manage Gateways", then you will have the option of choosing it.

 

So for you, you will need to check if your SQL and your SharePoint have been added as a data source in the "Manage Gateways".  This can be found as an option under the Cog icon in the top menu of Power BI Service.

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi Anonymous

     

    Another option to check what data sources you do have in your Power BI Dedsktop file is to go into the Query Editor, and then click on Data Source Settings.


    This will show you all the data sources that you are connecting to. Then as per Anonymous below, you can confirm that those data sources are also setup in the Power BI Service Gateway

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thank you again for your attention.

      Just to clarify, I know my data source from Desktop. When I go to Manage Gateway, it appears that I don't have any gateways.

      But the DBA confirmed to me that the gateway was installed on the server.

      In that case, should I install another gateway in my machine?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Anonymous,


        Which type of gateway does the DBA install for you, on-premises gateway or personal gateway? 

        If the DBA installs on-premises gateway , he should go to the administrator’s tab of the registered gateway to add you as additional admin, then you will be able to see gateway in "Manage gateway", and you are able  to add all data sources within the gateway.

        Regards,
        Lydia Zhang