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

Waiting for sharepoint

hi, 

 

would able be able to support me in resolving this issue? i am trying to refresh a dataset in desktop and for some reason it keeps sticking at the below. 

 

All credentials are correct 

 

 

Sharepoint Waiting.png

1 REPLY 1
Anonymous
Not applicable

Hi,

I'm guessing you've already done this since you said that your credentials are correct, but here are a few things you might try if you haven't already:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

Data refresh failure because of password change or expired credentials

Data refresh can also fail due to expired cached credentials. Clear your internet browser cache by going signing into Power BI and going to https://app.powerbi.com?alwaysPromptForContentProviderCreds=true. This forces an update of your credentials.

-OR-

You also might try clearing the cache from PBI Desktop in the Options

image.png

 

I recently had a huge SharePoint related refresh problem, that involved a bunch of expand records in my Query... If you are expanding people picker fields, those can severely slow down your query. I ended up expanding the "Field as Text" for all of my names and field values rather than expanding the records.

Hope that helps! Please reply back if not and I'll see if I can find anything further.

~Kim

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.

Top Solution Authors