Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filepath from same folder as the PBIX file(PowerQuery M language)

Hey PBI'ers,

 

I have a parameter with a filepath.

with """&FilePath&"" I intergate this as my source in de advanced script editor. 

But it's on my C: hardrive and I want have to implement 130 dashboards with the same data model.

So how can I get the currentfolder where the PBIX file is in + [filename](as my parameter input) in the

M language?

 

Thanks already, kind regards,

 

MrNelsch

  • Anonymous's avatar
    Anonymous
    7 years ago

    I fixed this by integrating "Sharepoint List" :)

    Using this tutorial: tutorial

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hey PBI'ers,

     

    I have a parameter with a filepath.

    with """&FilePath&"" I intergate this as my source in de advanced script editor. 

    But it's on my C: hardrive and I want have to implement 130 dashboards with the same data model.

    So how can I get the currentfolder where the PBIX file is in + [filename](as my parameter input) in the

    M language?

     

    Thanks already, kind regards,

     

    MrNelsch

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Do the dashboards (report pages?) need to be in separate PBIX files or can you have them all in a single PBIX file?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I fixed this by integrating "Sharepoint List" :)

      Using this tutorial: tutorial