I have a document library with document status as pending, approved, rejected. I want to show status of document in power BI. But column fields are not visible. enter image description here What must be the connector I have to use?

2 Answers 2


The “Approval Status” column is the default column in SharePoint, then you could create a custom column in the library. Then set the value of the custom column as the value of the “Approval Status” column.


Sorry for giving your confusion.

The “Approval Status” column is a lookup field and not applicable in the calculated fields.

Then we can use SharePoint designer workflow to set the value of the custom column as the value of the “Approval Status” column.

Because the “Approval Status” column is the lookup column, we cannot get the string value of the “Approval Status” column, we only can get the number of the “Approval Status” column.

  • But that column need to be updated manually? Sep 16, 2019 at 16:07
  • you could create a calculated column, and set the value of the column equal to the value of the “Approval Status” column. then you do not need to update the custom column manually.
    – Amy_MSFT
    Sep 17, 2019 at 0:39
  • Its showing me technical error, can u tell me exact formula? Sep 18, 2019 at 7:18
  • One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.- this is the error Sep 18, 2019 at 14:20
  • I have updated my reply.
    – Amy_MSFT
    Sep 19, 2019 at 2:45

You will find Content Approval Status & Commnets hidden in

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.