Importing an Excel PowerQuery

[Chelle]

Hi everyone, 

I am trying to import a Query into PowerBI desktop by using this:

=Excel.CurrentWorkbook(File.Contents("location\Input_full.xlsm"){[Name="QueryTableName"]}[Content])

but it gives me this:
Expression.Error: We cannot convert a value of type Binary to type List.
Details:  
Value=[Binary]
Type=[Type]

What I want is for PowerBI to extract the content of the Excel PowerQuery and import it as another query within PowerBI and not just a connection (like a table in excel, to be used as a source for other queries)

Is this even possible?

Thanks in advance.

[danextian]

Hi @Chelle ,

Excel.CurrentWorkbook is not a Power BI M  function. It is specific to Excel only.  Try this feature instead.

This will import the raw table that's within that workbook.  If you instead want to import the output of Power Query, you must load it to a table and then connect to that table using the Excel connector.

[Chelle]

I'll give it a try.  Thanks!