Forum Discussion

cboake's avatar
cboake
Frequent Visitor
5 years ago
Solved

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 ...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    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.

edhans's avatar
edhans
Community Champion
5 years ago

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's avatar
    cboake
    Frequent Visitor
    5 years ago

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

    • edhans's avatar
      edhans
      Community Champion
      5 years ago

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