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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
debjit
Regular Visitor

No Able to refresh data from Sharepoint

 

I am trying to refresh from excel file in sharepoint but the organizational account is not logging in. If see below there is a pop up with error in page load on task bar. But i am not able to select that or read that to understand whats happening. 

 

Please kindly help. 

 

debjit_1-1635510294311.png

 

1 ACCEPTED SOLUTION

Everything is normal in my test, please refer to the following steps:

1. Get data from web:

Vlianlmsft_0-1635930752852.png

2. Copy the path of the excel and delete"?web=1"

Vlianlmsft_1-1635930824995.png

Vlianlmsft_2-1635930912812.png

 

Login and refresh is normal.

Vlianlmsft_3-1635931035654.png

 

This is my desktop version

Vlianlmsft_4-1635931176645.png

 

View solution in original post

6 REPLIES 6
debjit
Regular Visitor

Same issue .. Please find below a screenshot

 

debjit_0-1635924135079.png

 

Everything is normal in my test, please refer to the following steps:

1. Get data from web:

Vlianlmsft_0-1635930752852.png

2. Copy the path of the excel and delete"?web=1"

Vlianlmsft_1-1635930824995.png

Vlianlmsft_2-1635930912812.png

 

Login and refresh is normal.

Vlianlmsft_3-1635931035654.png

 

This is my desktop version

Vlianlmsft_4-1635931176645.png

 

DRams_316
Frequent Visitor

Same issue and reentering credientials in the source settings didn't help 😞

amitchandak
Super User
Super User

@debjit , Go to data source setting -> Edit credentials and provide those again. and check

I tried that not working. If you see the screenshot I think the verification process is not triggering in the back end as there is something with a page load error 

 

When trying to connect to Sharepoint Online, Please do the following:

- Get Data > Web

- Enter the URL of the excel file (minus the ?Web=1 querystring)

Vlianlmsft_0-1635923448812.png

Enter URL using format like: https://XXXXX.sharepoint.com/sites/XXXX/Shared%20Documents/excelname.xlsx .

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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