Power Query Excel for Mac, privacy level rebuild data combination

[cboake]

Hi, I've got an Excel workbook that has several Power Query queries behind that data. The refresh works fine on the Windows computers I have tested it on but the workbook can't be refreshed in Excel for Mac. I receive the message "Query is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination" only in Excel on MacOS. Does anyone have any clues? Almost all of the queries were edited/ built manually if that makes a difference. I've gone in and changed the privacy levels to Public and then None but it doesn't seem to make a difference. Is there a way to change the privacy levels of hand-authored queries or would that not help? Again, this only happens in the Mac version of Excel.

[edhans · Accepted solution]

Hi @cboake - you may want to ask in this thread on the Technet forums. I'm going to go out on a limb here and say no, not yet. The privacy levels are not set in the M code, but as metadata outside of the query itself via the Power Query interface, which doesn't exist in the Mac. I am sure that feature is coming, but Power Query is very limited today on the Excel Mac version.

[cboake]

I believe this is the answer, we will have to wait for the Power Query interface to become available for Mac. Thank you!

[edhans]

Yup. Just have to monitor that Mac Excel thread and hope for more features soon.