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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors