Reply
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎01-24-2017

Power BI unable to connect to Excel workbook saved on SharePoint Online or OneDrive for Busi

I have linked a Sharepoint Online Excel file in my Power BI Desktop client and I can successfully write my reports and publish it to Power BI online.  I can not however get the Online app to schedule a refresh.  When I check the connection properties I only have the option for "WindowsWithoutImpersonation".    Trying to connect that way the dialog spins.

 

When I try adding the source file as a new Data Source using either a Sharepoint Team Site or OneDrive for Business both give me a connection error.

 

We couldn't import data from OneDrive - Business
 
Make sure you're entering the information correctly.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID9a06fbd4-2e0f-4cc9-81f2-ba9af0003258
Request IDf3dd7cab-5a9e-d5ca-505c-ee7cc9929ffb
Correlation ID1cd76466-ed98-4af9-1302-d2e748fe8d86
Status code400
TimeMon Feb 06 2017 11:54:44 GMT-0800 (Pacific Standard Time)
Version13.0.1700.1121