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
jhaastBI
Helper I
Helper I

Error: data source partially online

Hello,

 

Currently, one of my data sources returns the following error:

jhaastBI_0-1675337145198.png

 

The dataset is of the type ODBC and returns the erorr "Partially Online" since this monday. Before this monday, there was no error.

 

The dataset returns the following error:

jhaastBI_1-1675337205132.png

 

 

Can somebody tell me how we can resolve the partially refesh error?

I have alreay reinstalled the gateway and the ODBC connection.

 

Thank you in advance.

3 REPLIES 3
jhaastBI
Helper I
Helper I

Thank you for your response.

 

Only in one of the gateway clusters is the ODBC source defined and findable. Is that problemen? Until monday last week it was not.

yes, it is a problem. The Azure service has a built in load balancer that randomly picks the gateway cluster member it offers the mashup job (or the direct query) to.  Maybe you got lucky until now that the service always picked the cluster member that had a functioning connection.

lbendlin
Super User
Super User

One of your gateway cluster members is missing the ODBC definition for that data source. On all gateway cluster members go to the 64bit ODBC control panel, System DSN, and do a test of that connection.

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! Prices go up Feb. 11th.

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!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.