关于信息的Mac电源查询

[王小飞]

Hi, I was wondering where I could see the update history of power query for Mac and the introduction of pq for Mac！

With windows
What's the difference?

Thank you！

[artemus]

Yes the second link requires an organization email. The organization has controls on this site.

All non-datasource functions are avialable on Mac.

To the best of my knowledge, most functions in Windows Excel are also on Mac.

If you create a custom query with:

#shared 

you will see all functions avialable.

[artemus · Accepted solution]

Here is a list of non-datasource functions that are not avialable in Mac:

Geography.FromWellKnownText
Geography.ToWellKnownText
GeographyPoint.From
Geometry.FromWellKnownText
Geometry.ToWellKnownText
GeometryPoint.From
Table.AddFuzzyClusterColumn
Table.FuzzyGroup
Table.FuzzyJoin
Table.FuzzyNestedJoin

[artemus]

Our announcement: Import data from local files using Power Query in Excel for Mac - Microsoft Community Hub

Update history should be part of Excel update history

Difference from Windows: The Mac version has the same user interface as the online service at https://powerbi.com

and includes some features that the Windows version doesn't.

Note: Excel is currently the only way to use power query on a Mac.

[王小飞]

Hello

Can the second link be viewed only by using the company email address?

Also,which M functions are available on the Mac,thanks!

Best Wishes 

Wang