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
Solution 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.

     

    • STGMD's avatar
      STGMD
      Frequent Visitor
      4 years ago

      Actually the on premises Gateway is run on a PC that is online all the time.

      But the problem is, I am the owner of the dataset's, and I have created the Workspace for this purpose.

      Currently this is being done via a personal Gateway and our task is to migrate this personal Dataset to be available for all our colleagues.

      And since I take my laptop home and turn off the system when I am on holidays, it poses a potential risk, as others using the dataset's cannot refresh.

       

      So the problem is, how to set up the On-Premises Gateway so the dataset's can be refreshed by others while I am off.