cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gavin007
Helper IV
Helper IV

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. The former one is ok, but the later one encounter problem.

 

My question is, if the Pbi dataset is already connected to local source via personal gateway, in theory, when I connect to that dateset from PowerBi again, it is cloud to cloud. It shouldn't require gateway again. But anyway, if i add to gateway and enter my powerbi username and password, it will has the following error message.

 

"We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

 

Is there any special with pbi dataset gateway

 

Capture.PNG

Untitled picture.png

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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.

difference between personal gateway and enterprise gateway.JPG

 

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.

View solution in original post

5 REPLIES 5
v-stephen-msft
Community Support
Community Support

Hi @gavin007 ,


Sorry to disturb you...


But did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Stephen Tao

v-stephen-msft
Community Support
Community Support

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.

difference between personal gateway and enterprise gateway.JPG

 

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.

View solution in original post

StefanoGrimaldi
Solution Sage
Solution Sage

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.

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

I enable that in the gatway setting in Power Service. but it sill doesn't work.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors