Forum Discussion
One drive file and folder path to be made dynamic
Hiya good people, I am working with a couple of folders and the files therein - which are saved on onedrive, syncing between two machines. But the usernames and onedrive folder path names are...
We had the same issue and our fix was to do the ETL in PBI Service Dataflows. The ETL stays in the cloud and Desktop only has to pull down the final results at the end through your local internet connection. It's much, much faster both in editing the ETL and building the data model/reports in desktop.
Depending on how complex your flow is you can gain further improvements by chaining two dataflows together, one to extract from the files and the next to crunch the data.
Yes! This is what I do too when it gets really slow, it's worked pretty well for me.