Forum Discussion
Line chart POWER BI
Hi everyone,
I'm new to Power BI. I would like to create a line chart which updates daily (x-axis is the date) based on sharepoint file which updates daily. I am able to connect to the data source and plot line chart based on that, how do I get it updated daily while remaining the previous data? Below is example fo chart I would like to have.
This is what I would like to achieve
5 Replies
- Greg_Deckler
Community Champion
Well, you schedule a refresh in the Service to have it refresh automatically. However, Power BI does a full import and replacement of the data each time. If you SharePoint list maintains all of the data, that's fine. If it doesn't, well that's a problem.
- AnonymousNot applicable
I've configured the schduled refresh but all it does it show me the latest data. My sharepoint doesnt maintain previous data, so i'm guessing I need to find a way to store the previous data and link it to power bi. Is there any exmaple showing how this is done?
- AnonymousNot applicable
Hi Anonymous ,
You might refer this topic.
https://community.powerbi.com/t5/Service/Archive-monthly-reports-with-comments/td-p/946811.
and also check this document about how to use multiple datasets to create report.
https://docs.microsoft.com/en-us/power-bi/service-datasets-discover-across-workspaces.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi Anonymous ,
Check the document below about scheduled refresh in Power BI.
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh.
However the data will be replaced after you refresh the data.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.