Forum Discussion

gavin007's avatar
gavin007
Icon for Helper V rankHelper V
5 years ago
Solved

Standard Gateway is not selectable

I Build a report using composite model. After I publish from Desktop, I tried to set up the gateway for two dataset, one is a import table from local source, one is the direct query from Pbi Dataset....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi gavin007 ,

     

    Personal gateway does not support DirectQuery. So, your mixed query include the direct query table and personal gateway doesn't support direct query connection mode. You can refer to this article.

     

    For the data source analysis service, the information that you enter for Username and Password is used by the gateway to connect to the Analysis Services instance.

    The Windows account you enter must be a member of the Server Administrator role on the Analysis Services instance you're connecting to. If this account’s password is set to expire, users could get a connection error if the password isn’t updated for the data source. 

    Reference: Manage your data source - Analysis Services

     

     

    Best Regards,

    Stephen Tao

     

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

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

you have enable the update from cloud source option in the gateway main settings? for a PBI dataset you only need to gateway to be able to connect to internet and enable the use the cloud refresh option from the gateway.

gavin007's avatar
gavin007
Icon for Helper V rankHelper V
5 years ago

That is why you see "optional" in the screenshot.