Forum Discussion
Cannot refresh Sharepoint folder with files after 31st August
Hello,
Being unable to sync files on a sharepoint folder datasource whose date is younger than 31st August 2018.
Found a different thread that may hint to something similar to what I am getting but I am not using Salesforce.
I have tested:
- that access to SP folder permissions are set correctly.
- reducing the number of files, hence, rows, on the query
- that September file's structure is identical to the August versions.
None worked.
Also, if I move all files but the ones I want to show in the SP folder refreshing the query returns a "table is empty" result.
did a test separately to connect dirreclty to the september file . It worked.
connected to a local sync of the SP folder. It worked.
connected to the cloud SP folder. It did not work.
(see photo below)
Is this a problem with the Sharepoint Folder datasource connection?
It is key for this to work for one of the dashboards we use relies entirely on being able to pickup the new monthly files.
Help, please....
HI Anonymous,
Have you import any custom visuals to your report? If this is a case, it seems like a known issue who already list on support page.
Please take a look at support page to know more about this issue:
Customers who have Power BI reports that are stored in and refreshed from OneDrive and contain organizational store custom visuals can become corrupted when they refresh.
Regards,
Xiaoxin Sheng
Thanks for your reply Anonymous.
I had a custom visual but I have deleted it and the data still does not show.
BTW, my datasources are stored on a Sharepoint folder, not on a OneDrive location, if this is relevant.
Again, I do not get any errors. The data just does not refresh after 31st August.
Any additional ideas on how might this be happening?
Thank you for your help.