Forum Discussion

--ak--'s avatar
--ak--
Regular Visitor
4 years ago

SharePoint Workflow Reporting

Hello,

 

Could i get some help 

I've imported data from a SharePoint list which incorporates a workflow. I am trying to create a report where i can monitor the status of items within the list. Several fields i want to show are showing as ID's...please see image below.. So instead of showing the actual values in the sharepoint list Power BI is showing numbers...how can i get it to display the actual value?

Any help would be appreciated.

 

Thanks in advance

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

8 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, --ak-- 

     

    What's the source data you obtained in the power query? And what's the actual value?

  • --ak--'s avatar
    --ak--
    Regular Visitor
    4 years ago

    thank you for the response!

     

    the source data is a sharepoint list... the actual value is the current workflow status which has many values depending on the item status such as "manager approved, booking approved, booking declined" etc

     

    i had a similar issue when trying to see which manager approved each list item but this solved by pulling the site o-data and linking tables

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      --ak-- 

       

      What I am asking is the data of the first step when importing data, whether it is displayed correctly? Can you show me a screenshot?

       

      • --ak--'s avatar
        --ak--
        Regular Visitor
        4 years ago

        hello,

         

        here is a screenshot..i've had to redact some sensitive information but i am after the booking table, shown below