Forum Discussion
monojchakrab
Resolver III
Resolver IIIOne 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...
j_ocean
Helper V
Helper VWe 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.
monojchakrabResolver III
Resolver IIIThanks j_ocean - I am sorry I could not follow what you said. Could you give some kind of a workflow for the "ETL in PBI service dataflows"? Apologies for not being conversant with this. But seems to be something that could work. Thanks and appreciate