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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors