SOLVED

Link Power BI to SharePoint and update SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-209357%22%20slang%3D%22en-US%22%3ELink%20Power%20BI%20to%20SharePoint%20and%20update%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209357%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20out%20that%20i%20have%20a%20SharePoint%20list%20but%20some%20of%20the%20field%20is%20empty%20and%20i%20want%20to%20link%20my%20power%20Bi%20and%20automatically%20update%20those%20field%20by%20looking%20computer%20service%20tag.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20picture%20please%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20the%20service%20tag%20in%20the%20SharePoint%20list%20so%20after%20that%20it%20goes%20to%20power%20bi%20and%20look%20for%20that%20service%20tag%20and%20in%20Sharepoint%20which%20ever%20field%20is%20empty%20it%20will%20fill%20those%20field%20automatically.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-209357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209388%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20Power%20BI%20to%20SharePoint%20and%20update%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209388%22%20slang%3D%22en-US%22%3E%3CP%3EAkash...within%20Power%20BI%20create%20a%20new%20field%20and%20then%20you%20can%20specify%20an%20If...then%20statement%20to%20determine%20if%20the%20field%20is%20populated%20or%20not.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20BI%20won't%20update%20the%20fields%20in%20SharePoint%20automatically%2C%20it's%20a%20reporting%20platform.%26nbsp%3B%20You%20can%20accomplish%20the%20updating%20with%20PowerShell%20or%20a%20calculated%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326231%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20Power%20BI%20to%20SharePoint%20and%20update%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326231%22%20slang%3D%22en-US%22%3EToday%2C%20You%20can%20also%20create%20an%20APP%20that%20updates%20SharePoint%20and%20run%20it%20from%20inside%20a%20Power%20BI%20Report%2C%20it%20works.%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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.

2 Replies
best response
Solution

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.

Today, You can also create an APP that updates SharePoint and run it from inside a Power BI Report, it works.