Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to change gateway for dataset

Hello,   I'm having trouble selecting a gateway connection for one of my reports. I'm not sure why, as this report uses the same datasource as some other reports which refresh just fine.   I have...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We noticed that your gateway cluster has a warning icon and seems it is offline, could you please try to verify the status of your gateway cluster in "Services" - "On-Premises data gateway", or open the gateway application?

     

     

    If you cannot select Personal Gateway to use in PowerBI Service, we think maybe you are using Direct Query to connect your data source?Please also refer to this document about difference between two modes of gateway: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode


    Best regards,

     

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

Hi Anonymous ,

 

We noticed that your gateway cluster has a warning icon and seems it is offline, could you please try to verify the status of your gateway cluster in "Services" - "On-Premises data gateway", or open the gateway application?

 

 

If you cannot select Personal Gateway to use in PowerBI Service, we think maybe you are using Direct Query to connect your data source?Please also refer to this document about difference between two modes of gateway: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, thank you for your reply.

 

Strangely, the gateway doesn't show up in services, but the gateway application (and the PowerBI service) show the gateway is up and running.

 

 

 

I looked at the report again and found one of the queries was using Direct Query. I replaced it with a query which uses Import connectivity mode and the report successfully refreshed. Thank you!

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

    Hi Anonymous ,

     

    The On-Premises Data Gateway has two different mode, one is Standard Mode, and another is Personal Mode, both can run in a same machine, but only Standard Mode can support DirectQuery and LiveConnection, each dataset can only use one gateway at same time. The Standard Mode run as a windows service, you can restart/stop it in the windows services manager, or using it's manage application: On-Premises data gateway, the manage application of personal mode is called On-Premises data gateway (personal mode), if you cannot find standard mode application or service in your computer, it mainly because it does not installed in this machine yet.

     

    It should notice if you convert a data source from DirectQuery to Import, we cannot convert it back to DirectQuery unless import this data source again using DirectQuery.


    Best regards,