Forum Discussion
crln-blue
Post Patron
Post PatronDoes summarized table from SharePoint excel refresh when excel data is refreshed?
Hi! I made a summarized table (and a calculated column on that summarized table) from my main table where its source is from an Excel file in SharePoint. From time to time, an admin will replace the ...
Hi crln-blue ,
"if the source data is updated, will the summarized table be updated too?"
-Yes. If your admin just upload the updated file to sharepoint to replace the initial file with the same file name, after you refresh the dataset in power bi service(need not a gateway because it is a web data source), the source data will be refreshed. Also, the summarize table and the calculated column will also be refreshed becasue both of them are created based on the source data.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super Usercrln-blue , I think they should get updated, after refresh the data.