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
christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Oh - just change the path that it's looking for the file to the web-synced OneDrive URL. All of the OneDrive folders are synced up to M365, so if you connect to it in the cloud instead of the local copy, it will always be the same. 

 

Here are a couple videos on how to change the source from local to SharePoint (or OneDrive - concept is the same) - one for changing individual file references  and one for folder connector references.

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

christinepayton - that is my current solution actually. But every time I open the query, the files take an eternity to load and furnish. That is why I was looking for a local path solution. But thanks for the leg-up.

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

    • christinepayton's avatar
      christinepayton
      Icon for Most Valuable Professional rankMost Valuable Professional
      2 years ago

      Yes! This is what I do too when it gets really slow, it's worked pretty well for me.