cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wozito
New Member

Power BI Services data source connection with Azure SQL without on-premise data gateway

Hello everyone,

 

I would like to know if Microsoft have enable in Power BI services a direct data source connection SQL Azure? So there would be no need to install a server with on-premise data gateway.

 

Any help in this issue would be really helpful.

Have a nice day!

 
2 REPLIES 2
Super User I
Super User I

Re: Power BI Services data source connection with Azure SQL without on-premise data gateway

@wozito, that is certainly possible.

However, you have to take into account a few things:

  • Specify the fully qualified server name when connecting (see below for more details).
  • Ensure firewall rules for the database are configured to "Allow access to Azure services."
  • Every action such as selecting a column or adding a filter will send a query back to the database.
  • Tiles are refreshed every hour (refresh does not need to be scheduled). You can adjust how often to refresh in the Advanced settings when you connect.
  • Q&A is not available for DirectQuery datasets.
  • Schema changes are not picked up automatically.

At our company point 2 is a NO go for IT/security, so we're currently not able to do this.

For more info have a look at Azure SQL Database with DirectQuery.

 

Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.com
Twitter: @NickyvV



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

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


wozito
New Member

Re: Power BI Services data source connection with Azure SQL without on-premise data gateway

The information given was very helpful however when checking the links it references Power BI Desktop or this applies also for "Power BI Services"? If yes could you please tell me how to configure it. 

 

Thanks

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.