Forum Discussion
Too long to Refresh - OneDrive for Business
Hello PBI Community, I have multiple Excel files (6 files) and Folder (Contain 15 or so XL files) on my OneDrive for Business, then I import them to PQ using Sharepoint.Content. - I have a Quer...
Thank you for your comment.
I am using the root folder, like this thread
I have also faced this problem due to the slowness of that connector and, for the time being, I have solved it as follows:
- I use one parameter to direct the connection to the OneDrive with all the data or to another that contains very few rows.
- I perform transformations in PQ by connecting to the OneDrive with few-row files to minimize slowness.
- Once all the transformations have been done, I modify the parameter to point to the final OneDrive.
- I'm in the cloud.
- I'm upgrading from the cloud thereafter, as it's faster than the on-premises upgrade.
- If I need to make new modifications to PQ I point again to the OneDrive with small files.
It's not the ideal solution, but it can help you while finding a better way.
Best regards.