Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

=Excel.CurrentWorkbook()

How work this function? =Excel.CurrentWorkbook()  Which is current workbook? I always got emtpy fields Do i need specify any workbook name and path? Do it take everithing from Activeworkbook?
Need Help
FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Analitika 

CurrentWorkbook is the workbook you're in and using Power Query. Power Query lists in a dialog all the items in this current workbook that are in this workbook.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

    FrankAT   but im not in workbook im in PBI desktop

    • FrankAT's avatar
      FrankAT
      Community Champion
      5 years ago

      Hi Analitika 

      so you can't use this function!

      With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
      FrankAT (Proud to be a Datanaut)