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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cheryl-lee33
Helper I
Helper I

Refresh of SharePoint data source updated or not?

Hi,

 

I hope someone can advise me what has happened.  I have a couple of Power BI reports using SharePoint folders as source data.  The scheduled refresh has been fine.  Yet, just now, I noticed something strange.  When I refreshed the data, I did not receive any error message.  However, under the gateway connection, I saw the following:

cheryl-lee33_0-1611069022084.png

There seems to be a cross for the SharePoint data.  When I connected to the source data in either Power BI desktop or Power BI Service, I can connect to the source without any problem.  As soon as I published the report to Power BI desktop, SharePoint data source always shows as above. 

 

Is there a problem?  What should I do to fix it?  I have signed in Microsoft365 for sure.  Also, I have checked my Data source credentials using "Edit credentials", and there is no error message either.  

 

Any input and suggestions are much appreciated.

2 ACCEPTED SOLUTIONS
blopez11
Super User
Super User

I don't believe there is anything wrong

You don't need to use the gateway for that data source, since it is in the cloud

However, I believe you have the option to do so, and that is why it shows up there

View solution in original post

Yes, they get added automatically, to give you the option of refreshing them through the gateway

I think if a data source in your dataset is supported by the gateway, it will show up by default

View solution in original post

3 REPLIES 3
blopez11
Super User
Super User

I don't believe there is anything wrong

You don't need to use the gateway for that data source, since it is in the cloud

However, I believe you have the option to do so, and that is why it shows up there

Hi @blopez11 ,

 

Thank you for your reply.  If there is no problem, that's great. 

The thing is that I did not specific add that source to use the gateway.  It seems to have added it automatically and then show me the red cross.  That is why I got confused.

Yes, they get added automatically, to give you the option of refreshing them through the gateway

I think if a data source in your dataset is supported by the gateway, it will show up by default

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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