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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
dgrant
Advocate I
Advocate I

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

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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