Forum Discussion

Anonymous

Not applicable

6 years ago

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 a...

Community Champion

6 years ago

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.

Anonymous
Not applicable
6 years ago
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?
- Anonymous
  Not applicable
  6 years ago
  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.
  - Anonymous
    Not applicable
    6 years ago
    Hi Anonymous ,
    Thanks for the input but I don't think that solution is suitable in my case as my dataset is refreshed daily. Is there any way to automate it instead of doing it manually?