We're currently experiencing issues with report refreshes due to the interaction between the sharepoint connector and retention policies. If the user performing the refresh is an owner of the sharepoint site with the data, than the process will fail because the connector will load also the files in the "preservation hold library". In our case these files have been deleted because they had malformed data, and replaced by the correct ones.
In my opinion it would make sense to have the connector ignore the preservation hold library by default, making it available with a flag for users that might need it for specific use cases.
v-yetao1-msft
on:
Matrix - Per Column Level - Show Subtotal off :- R...
Hi @lfschin ,
Thanks for this idea and I do suggest you submitting it in Power BI Ideas. There, our product team will collect the needs and suggestions from users, and take them into considerations when designing or improving this product. Thanks in advance!
Link of Power BI Ideas: https://ideas.powerbi.com/ideas/search-ideas/?q=Preservation%20Hold%20Library%20%20sharepoint
Best Regards,
Community Support Team _ Caiyun