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...
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
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.