Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
王小飞
Frequent Visitor

关于信息的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!

1 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

 

View solution in original post

4 REPLIES 4
artemus
Employee
Employee

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.

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
Employee
Employee

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors