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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
praveen571
Helper I
Helper I

PowerBI Embedded On-Premises Direct Query on Azure SQL

Hi ,

 

I have found some other way for the Direct query (live connection) using ssas tabular model with help of azure.

 

On-premises Server-->(Bridge Connection)->Azure DatawareHouse -->PowerBI-->Azure PowerBI Embedded Service.

 

This helps to publish our report on the web with live data.But, I don't have any document how to achieve this.

If you folks find something related to this kindly share to me. 

 

 

Thanks,

Praveenkumar.K

3 REPLIES 3
v-ljerr-msft
Employee
Employee

Hi @praveen571,

 

For the "Azure DatawareHouse -->PowerBI-->Azure PowerBI Embedded Service" part, you can refer to this article which describes how to get started with Microsoft Power BI Embedded step by step. Or you can try getting started with Power BI Embedded sample.Smiley Happy

 

Regards

Hi v-ljerr-msft,

 

I have tried the sample and its working fine. But it's not allowing On-premises database direct query to pull live data, I have to use Azure as the source for PowerBi direct Query. Instead of that, I'm trying to connect my on-premises database to powerBI direct query through the Azure.

 

I have found a similar way in AZURE  named as "Hybrid Connection".I'm not sure how it's useful to accomplish below scenario.

 

On-Premises SQL -->Azure SQL-->(Direct Query) PowerBI.

 

Help me out how to connect this hybrid connection.

 

Regards.

 

 

 

Hi @praveen571,


I have tried the sample and its working fine. But it's not allowing On-premises database direct query to pull live data, I have to use Azure as the source for PowerBi direct Query. Instead of that, I'm trying to connect my on-premises database to powerBI direct query through the Azure. 


Yes, it is still a limitation that we cannot use DirectQuery with on-premises data sources for Power BI Embedded currently.

 

For the "On-Premises SQL -->Azure SQL-->(Direct Query) PowerBI" part, as I'm not familiar with "Hybrid Connection" and don't know how it works, I'm not sure if it could work for Power BI Embedded(Direct Query). Based on understanding, only if the "Hybrid Connection" do make the On-Premises SQL work as a Azure SQL, I don't think it could help much here.Smiley Happy

 

Regards

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors