Excel Power Query vs PowerBI Power Query

[krrishkrsna]

Hi,

in Excel > Table > Power Query > From Table. so table data will be in Power Query
in PowerBI > Table > Power Query > option not found

plz help on this

 

[AliGW]

What exactly are you trying to do? If you create a query in Power Query in Excel, when you then import that workbook into Power BI, it will be one of the tables available. Are you using Power BI Desktop or online?

 

[krrishkrsna]

in Excel we convert Data into Table and we use From Table command in Power Query to get data into Power Query
in PowerBI, created one calendar table (=Calendar(StartDate,EndDate)) and trying to export to power query as i did in Excel Power Query

i think this helps you to answer my question

 

[AliGW]

You haven't answered my question: are you using Power BI desktop or Power BI online? The functionality is different.

In the desktop version, if you create a table and then edit it, it automatically gets loaded with the PowerQuery toolbars available at the top.

 

[krrishkrsna]

hi

using Power BI desktop but not working as we do in Excel Power Query.

some functions wont work in Excel Power Query but in Power BI Power Query do work ie., returns result.

is Power BI and Power Query nullifying the Excel in coming days. plz clear this doubt

 

[AliGW]

I think you are going to have to be much more specific about what it is you are having difficulties with if anyone is going to have a chance of properly answering your questions. As for Microsoft's future plans, how would I know? Ask them.

 

[krrishkrsna]

hmmm ok AliGW. will ask