Forum Discussion

dandurocher's avatar
dandurocher
Frequent Visitor
3 years ago
Solved

SharePoint recent files not showing up

When connecting Power BI to SharePoint Folders, recent files are not visible. I am logged into my corporate account, which has access to tools like M365, SharePoint, and Power BI. Some time ago, ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi dandurocher ,

     

    When you opened it in Power BI Desktop, please go to Data source settings and check or edit your permission of SharePoint to make sure it's correct and up to date.

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

     

     

Serenge's avatar
Serenge
Frequent Visitor
1 year ago

I realised the best way to handle this is to clear up Cached data that is saved on BI desktop. Go to File > Options and Settings > Options > Global > Data Cache Management Options > Clear Cache . Afterwards repeat the import process from your sharepoint folder you will notice that you can now view the new files. The only problem is that you will have to repeat said process everytime you add a new file in your sharepoint folder and you want to see it on Power BI Desktop. 

Lawrenceiow's avatar
Lawrenceiow
Advocate I
6 months ago

Thanks, clearing the cache worked for me. In my case it wasn't permissions that was the problem.

Of course, it'll clear all cached data not just the sharepoint data.