cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MontsePuig
Frequent Visitor

Power BI in a Cloud

Hi, everyone.

 

I have a question, It is possible to use power BI with a repository directly such as SQL Server or Datawarehouse in Microsoft Olap, or I am forced to connect to the Azure services.

 

Thank you very much

2 REPLIES 2
v-sihou-msft
Microsoft
Microsoft

@MontsePuig

 

If you want to connect on-premise SQL Server or SQL Datawarehouse, you just need to install the On-Premise Gateway. Power BI has Cloud Gateway Service which can find the Application Gateway via Azure Service Bus. For more details, please see: On-premises data gateway in-depth.

 

Regards,

tringuyenminh92
Memorable Member
Memorable Member

Hi @MonstePuig,
For source connection, you could connect to sql server or another source in on-premise and using enterprise gateway for refreshing. The list supported source you could check https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-sources/
When you publish Pbix file to power bi service, it's cloud. But MS has informed another deploy approach to allow publish Pbix file to reporting service 2016 as on-premise deployment solution. Its in technical preview now https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/10/25/announcing-a-technical-preview-of-power-bi...
And the plan is mid-2017 for GA as my observation.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors