Forum Discussion
Weekly data analysis
Power BI can handle that, but you can make it even easier by setting up incremental refresh as demonstrated in this video. It uses SharePoint for file storage (which you should consider), but could easily be adapted for use with the Folder connector.
Incremental Refresh with SharePoint Files - YouTube
Pat
Solution SagePower BI can handle that, but you can make it even easier by setting up incremental refresh as demonstrated in this video. It uses SharePoint for file storage (which you should consider), but could easily be adapted for use with the Folder connector.
Incremental Refresh with SharePoint Files - YouTube
Pat
Thank you, that is exactly what I was looking for! And I will migrate everything to SharePoint, thanks!
Could you show me how to pull the same metric (let's say, number of rows) from 12 monthly files in my SharePoint folder and show them on a chart with month as X-axis? Should I use Measures for that?
- ppm1
Glad that will work for you. Once you combine the files, you have a single table with all your data. You can choose to keep the original file name (or date), so you can easily create visuals that show the row count from each (yes, with measures). You should next consider adding a Date table to your model, to easily slice/dice by day, week, month, year, etc.
Pat