Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

On premises data connection to power BI service

Hi experts, 


On my power BI desktop, I am able to connect to on-premises oracle database and develop KPI dashboard with live data. But, when I publish it to my workspace, the dashboard is not able to refresh the real live data. I found that we need a gateway to create a connection between PBI service and on-premises database. But without the gateway, can we use Python script to directly pull out the data from on-premises database?  I am really clueless and if there is a way, could you help to share how to achieve that? 


Thanks alot!

Helper I
Helper I

Hi @MeiYing : For any on premises data source, you need a gateway. Power BI services is outside your on premises network and for Power BI to reach to your database, you need a gateway connection configured on the Power BI service to be able refresh the dataset. 

You can read more about it here : On-premises data gateway - Power BI | Microsoft Learn

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors