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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
cboake
Frequent Visitor

Power Query Excel for Mac, privacy level rebuild data combination

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.

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
cboake
Frequent Visitor

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

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors
Top Kudoed Authors