Showing results for 
Search instead for 
Did you mean: 
Alay Regular Visitor
Regular Visitor

When will we be able to data from an on-prem sql server database?

Hello Power BI Development team,


When will we be able to Get Data from an On-premise SQL Server Database instance? We can't do that in Power BI Online. 


Tks & Rgds,



Super User
Super User

Re: When will we be able to data from an on-prem sql server database?

@Alay I'll preface this response by saying the following: 1) I'm not an MS DEV 2) you may already know this.

But I'll say this anyway. While you can't directly connect to an on-prem SQL instance from the service. You can connect via the Power BI Desktop and publish the file to the service, which in essence gives you a connection to your on-prem SQL instance...which can be refreshed via the personal gateway.

Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 110 members 1,726 guests
Please welcome our newest community members: