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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors
Top Kudoed Authors