Forum Discussion

crln-blue's avatar
crln-blue
Icon for Post Patron rankPost Patron
6 years ago
Solved

Does 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 ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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 Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

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 Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.