Forum Discussion

Deleted's avatar
Deleted
Jun 27, 2018
Solved

Link Power BI to SharePoint and update SharePoint list

Hello 

 

I am trying to find out that i have a SharePoint list but some of the field is empty and i want to link my power Bi and automatically update those field by looking computer service tag. 

 

I have attached the picture please advice.

 

i have the service tag in the SharePoint list so after that it goes to power bi and look for that service tag and in Sharepoint which ever field is empty it will fill those field automatically.

  • Akash...within Power BI create a new field and then you can specify an If...then statement to determine if the field is populated or not.

     

    Power BI won't update the fields in SharePoint automatically, it's a reporting platform.  You can accomplish the updating with PowerShell or a calculated field.

4 Replies

  • Akash...within Power BI create a new field and then you can specify an If...then statement to determine if the field is populated or not.

     

    Power BI won't update the fields in SharePoint automatically, it's a reporting platform.  You can accomplish the updating with PowerShell or a calculated field.

    • Andres_Martinez's avatar
      Andres_Martinez
      Copper Contributor
      Today, You can also create an APP that updates SharePoint and run it from inside a Power BI Report, it works.
      • Jul_-YCH's avatar
        Jul_-YCH
        Copper Contributor

        Andres_MartinezI've been trying to find information about this method. Can you point me to a good description of how you would do that?

        Thanks

Resources