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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors