Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

jgilbertson

Can't connect to OneDrive Business Excel Workbook

Submitted by on ‎01-23-2017 01:03 PM

I am trying to connect to a workbook (created in Excel 2016, .xlsx) in OneDrive - Business that has connections to SQL tables and am getting the error below. My goal in creating the connection is to schedule periodic refreshes from the data sources in the workbook.

 

data refresh error.png

 

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎01-25-2017 12:11 AM

@jgilbertson

 

I just tried the same scenario as you but everything worked well as below. Could you please try with some other simple excel files which do not have connections to SQL tables to see if it is related to the connection between Power BI and your OneDrive Business?

 

Can't connect to OneDrive Business Excel Workbook_1.jpg 

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎01-25-2017 12:12 AM
Status changed to: Needs Info
 
Idea Statuses