Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NISH72
Helper IV
Helper IV

SharePoint to power bi

Hi
I have data in SharePoint in this format.
Cust name, cust sales, cust comment
A. 56 good
B. 23

If some user makes changes in the cust comment in SharePoint I should only be able to import that particular row in power bi. For eg if someone commented good for customer A Then only customer A row should be imported in power bi and not customer b row. Please help me if there's any dax or SQL or any other method I can use. Sorry I am unable to share the data as it's confidential. Thanks
6 REPLIES 6
v-frfei-msft
Community Support
Community Support

Hi @NISH72 ,

 

You should publish the report to service to keep it being refreshed.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi thanks for the reply. But it's still unclear for me that how can I populate changed data that's in SharePoint to powerbi. Thanks
Cmcmahan
Resident Rockstar
Resident Rockstar

This is a feature called Incremental Refresh, and is only available in PowerBI Premium.  

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh < look for the section on Detect data changes

The other way would be to set up a live connection, which pulls current data every time. 

 

 

Thanks for the reply. Actually I want to see the changes in power bi desktop and don't want to publish the reports to workspace and I cant connect live because data source is SharePoint. Thanks please help me with this

Unfortunately there is no way to currently only update data where there are changes detected in Power BI Desktop. It either pulls the entire dataset, or nothing at all.

No. I want to populate the fields in power bi desktop if the changes are detected in SharePoint. For eg if row 1 is edited in SharePoint then populate only row 1 in power bi desktop not row 2. Thanks

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.