Forum Discussion

LY18's avatar
LY18
Icon for Helper I rankHelper I
6 years ago

Manual refresh impossible for some admin with personal gateway

Hi,

 

Due to intern limitation, we could not activate a entreprise gateway .... All the report and workspace are connecting through a personal gateway using my company account.

 

for a long time it was working fine, the automatic refresh are running fine

and if another admin of the workspace needed it , he could do a manual refresh of a particular dataset

 

Since now 2 weeks we have issue with some people that could not use the manual refresh (even if they are admin !) 

it's very disturbing because some people can, some people have acces to some workspace but not to all of them, and some other users have no more access to any refresh ...... while everyone is admin on all worksape

 

i really don't get it

 

Do you know if Microsoft change recently some rules on how to deal with manual refresh ?

 

many thanks for your help ....

Need Help

3 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, LY18 

     

    I have some questions:

    1. Which data sources you are using?

    2. Which connectivity mode is adoptted?

    3. Are the data source and the gateway on the same machine?

    4. Is there any error message?

     

    The following table describes differences between an on-premises data gateway and an on-premises data gateway(personal mode).

      On-premises data gateway On-premises data gateway (personal mode)
    Cloud services supported Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows Power BI
    Runs As configured by users who have access to the gateway As you for Windows authentication and as configured by you for other authentication types
    Can install only as computer admin Yes No
    Centralized gateway and data source management Yes No
    Import data and schedule refresh Yes Yes
    DirectQuery support Yes No
    LiveConnect support for Analysis Services Yes No

     

    For further information, you may refer to the document . I'd like to suggest you update the gateway to the latest version to see if if help. If it still doesn't work, you may open a support ticket here .

     

    Best Regards

    Allan

     

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

    • LY18's avatar
      LY18
      Icon for Helper I rankHelper I
      6 years ago

      First thanks for the answer 

       

      so : 

      1:  data sources are files (excel) on sharedrives . Every one have access to them... and from what i understand , when someone press the manual refresh on the service , the "power bi service" is using my personnal gateway , to connect with my account ... so this shouldn't be blocking .... 

       

      2: i don't understand the question ... what do you mean by "connectivity mode" ?

      all reports have a automatic refresh daily , working perfectly fine.

      I can use the manual refresh without issue.

      but for some reasons on some reports, admins can't use the manual refresh , and on other reports they can ...

      i can't figure out if there is a setting somewhere .... the gateway is the same for all reports ... all user have the same level (admin) ....

       

      3:  data source are on a sharedrive, Gateway is on a fixed computer on the network 

       

      4: yes , user that can not refresh manually got this message 

      of course i confirm the gateway is online 😉

       

      does it give you some ideas ?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    I am also facing this issue. Can you solve it finally?

     

    BR,

    Jason