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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
teros
Helper I
Helper I

Azure-hosted report where data does not reside in cloud?

Is there a way to configure an Azure-hosted Power BI Report or Dashboard such that its data is always fetched from our on-premises database servers, rather than in the cloud? Data "just passing through" could be acceptable, but having the data prefetched from our servers are served to end-users from the cloud is not.

1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion

@teros If I understand your question correctly you are talking about the Power BI Service (cloud Saas offering)

There are several ways you can leverage reports that always connect directly to your on-premises datasources and the data is kept in those locations. The connection type is what is important here. I've blogged about this here if you want to take a look. Essentially, you can use Direct Query or a Live Connection.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1
Seth_C_Bauer
Community Champion
Community Champion

@teros If I understand your question correctly you are talking about the Power BI Service (cloud Saas offering)

There are several ways you can leverage reports that always connect directly to your on-premises datasources and the data is kept in those locations. The connection type is what is important here. I've blogged about this here if you want to take a look. Essentially, you can use Direct Query or a Live Connection.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!