Forum Discussion
=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?
Hi Analitika,
In fact, there are a few differences between excel and power bi and correspond Dax/m query formula. (it probably related to excel/ power bi data models, mechanism, and backend processing)
As MFelix said, the function that you mentioned seems like required some global variables that excel provided so it can't work properly on the power bi side.
Regards,
Xiaoxin Sheng