Forum Discussion

redhughes's avatar
redhughes
Helper II
7 years ago

Affordable and user-friendly database solution

Hi,   First of all we're a small business and without a proper IT department or IT background, We use PowerBI for reporting and have a few data sources - Podio (via Web data feed), Excel spreadshee...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Jan,

 

1. The Gateway (personal) can be used by one user at the same time. That means it can be used by many users but only one account can be logged in at a time. If we switch accounts time to time, that would be a disaster. 

2. The scheduled refresh is still available for the Gateway (personal). So if you set up the scheduled refresh in the Service side, your colleagues only need to update the data sources such as the database, Excel files. 

3. The most important part is all the members of an App workspace can refresh the dataset by clicking "Refresh Now". So you set up the Gateway and your colleagues just use it. Please refer to the snapshot below.

Affordable-and-user-friendly-database-solution

 

Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode#limitations-and-considerations

 

 

Best Regards,
Dale

redhughes's avatar
redhughes
Helper II
7 years ago

v-jiascu-msftthanks for the reply. does it still mean that I (my laptop) has to be online when the other user is refreshing the data?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi redhughes,

     

    Yes, you are right. The Gateway is a bridge. You need to keep it open.

     

    Best Regards,
    Dale