Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
andykmwong
Helper III
Helper III

On-Premises Gateway Issue : Publish Power BI Reports fail to connect to gateway

Dears,

 

According to screen shot below does the On-Premises Gateway still not yet created since I have install the application gateway on my laptop in domain, seems due to group policy cannot connectto Azure Services ?

 

Anyone knows do I need to click "Create a Gatway" to Azure Services ?

 

Thanks !

Andy Wong

 

01.JPG02.JPG03.JPG04.JPG

1 ACCEPTED SOLUTION

Hi @andykmwong,

 

From screenshots, it seems that the report get data from SQL Server database in DirectQuery mode. Right?

 

After publish the report to service, there is no available data gateway or data gateway is offline. So in your scenario, please go to dataset settings, then check which data gateway used.

 

w1.PNG

 

If no data gateway used by dataset, please go to Manage Gateways, create a data source under gateway use the same connection information used in desktop. For more information, see: Manage your data source - SQL Server.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
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

2 REPLIES 2
andykmwong
Helper III
Helper III

05.JPG

Hi @andykmwong,

 

From screenshots, it seems that the report get data from SQL Server database in DirectQuery mode. Right?

 

After publish the report to service, there is no available data gateway or data gateway is offline. So in your scenario, please go to dataset settings, then check which data gateway used.

 

w1.PNG

 

If no data gateway used by dataset, please go to Manage Gateways, create a data source under gateway use the same connection information used in desktop. For more information, see: Manage your data source - SQL Server.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors