Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
2 years ago

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...
Need Help
j_ocean's avatar
j_ocean
Icon for Helper V rankHelper V
2 years ago

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.

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
2 years ago

Thanks 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

  • j_ocean's avatar
    j_ocean
    Icon for Helper V rankHelper V
    2 years ago

    monojchakrab Dataflows are just Power Query Online. You can build your PQ there or even just copy-paste what you have out of Desktop.

     

    Go to Power BI Service (online), to any workspace other than "My Workspace," click "new," and there should be an option for dataflows.

     

    Then Desktop connects to the dataflow and reads in nice clean tables. No processing done on your machine and only the final data goes over your local network.