Forum Discussion

Brass Contributor

Feb 22, 2023

Solved

Refresh Power Query loaded to Data Model in Excel Online OR in Mac

Hi, I have created some Power Query queries that take data from Dataverse and load it to a Data Model inside Excel. Some Pivot Tables are generated from this Data Model. The Excel file is hosted in ...

excel

Excel for web

Excel on Mac

Riny_van_Eekelen
Feb 22, 2023
Shalem120 You are correct on the limitations observed. PQ for the Mac does NOT support Power Pivot / Data Model. You simply can't use or refresh workbooks containing these features on a Mac. You are limited to the following connectors.

Riny_van_Eekelen

Platinum Contributor

Feb 22, 2023

Shalem120 You are correct on the limitations observed. PQ for the Mac does NOT support Power Pivot / Data Model. You simply can't use or refresh workbooks containing these features on a Mac. You are limited to the following connectors.

Veaceslav_Peresnicenco

Copper Contributor

Feb 14, 2024

Riny_van_Eekelen

Hello.

What about the insider beta version?

link: https://support.microsoft.com/en-us/office/import-and-shape-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5

It still has issues with commenctivity.

Riny_van_Eekelen
Platinum Contributor
Feb 14, 2024
Veaceslav_Peresnicenco Not sure why you highlight the SQL connector. This thread is about the Data Model on Mac,