Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI + Gateway

Hi All,   I have been asked by user to setup Gateway for his Power BI. I have absolute zero knowledge so would appreciate any help on setting this up.   So far i have installed  On-premises data ...
Need Help
Tutorial Requests
Watsky's avatar
Watsky
Icon for Solution Sage rankSolution Sage
4 years ago

Hey STGMD,

 

Did Anonymous  add your data source to the gateway with credentials then add you as a user? If so what happens when you go to your data source on the service then to the Gateways. Do you see the gateway?

 

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I havent add the data source as i am not sure what to add as data source.

  • Watsky's avatar
    Watsky
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hey Anonymous , 

     

    STGMD will need to provide you with the data source that he is using for his reporting. It'll need to be setup the same way for the gateway. If it's a database connection you may want to make sure you get credentials that have access to all tables so that if someone in the future needs access then they will be able to access the same tables. Once the connection is created you'll then have to add STGMD  and any other user as a user of the data source on the Gateway. 


    Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
    Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

    • STGMD's avatar
      STGMD
      Frequent Visitor
      4 years ago

      Thank you for the responses!

      We will test this and see how it goes!

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous 

        According to STGMD , I think your problem is that you want to refresh your report successfully if the gateway owner is offline or the PC with gateway is turned off. I think that's impossible. Power BI on-premises gateway works like a bridage to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.You need to keep the machine which has the gateway and the data source (if your data soucre is in local.) turned on. Or your refresh will failure.

        Here is the offical blog about on-premises data gateway

        Here is the offical blog about how to add data source or user in your on-permise gateway.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.