Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 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
Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago

MFelix  from which excel file?

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 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
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    FrankAT   but im not in workbook im in PBI desktop

    • FrankAT's avatar
      FrankAT
      Icon for Community Champion rankCommunity Champion
      6 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)