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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KPRL
Frequent Visitor

Power BI dataset refresh issue : SQL Server hosted on Azure is showing offline

Hello,

 

I have a report based on SQL server hosted on Azure. After publishing the report trying to add a vnet gateway for scheduling the dataset. However, It was throwing some unknown error while trying to assign the gateway. Later, found the datasource (SQL server) status is showing offline even though it was active and could run queries. 

Could anyone please help me on this ?

 

Thanks!

1 ACCEPTED SOLUTION
KPRL
Frequent Visitor

Hi @GilbertQ ,

 

Thanks for your reply. This is resolved now. 

Not exactly sure what went wrong but my best guess is that the issue was with Gateway setup(Authentcation Method).

 

Cheers!

View solution in original post

4 REPLIES 4
janesbenth1
New Member

@wordle Thank you. Your post presented me with a wealth of information, allowing me to broaden my horizons

GilbertQ
Super User
Super User

Thanks for letting us know!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @KPRL 

 

Are you using Azure SQL Database?

 

if you are you should then be able to connect without a VNET Gateway.

 

Please make sure that you follow the steps for setting up the VNET Gateway here make sure that you are using Power BI Premium or Power BI Premium Per user workspaces: Use virtual network (VNet) data gateway and data sources in Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

KPRL
Frequent Visitor

Hi @GilbertQ ,

 

Thanks for your reply. This is resolved now. 

Not exactly sure what went wrong but my best guess is that the issue was with Gateway setup(Authentcation Method).

 

Cheers!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors