I'm new to Power BI and I would like to get some help in what I'm required to do.
My task is to create a dashboard on a comapny SharePoint that will display Food and Beverage statistics. As the reports from the POS system are presented and saved in an Excel they are useful for creating visuals but I have encountered few problems so far. As the reports from POS are cluttered with information on a different levels I have to spend lots of time to tidy them and sometimes split them into smaller tables. Is there a way to deal with tables with data on different levels that can be used by Power BI? Bwlow there is an example of the report from POS.
My second question is regarding refreshing data. The POS system can generate and export files to the specific locations on local drive or to OneDrive but it will overwrite the file that it was used previously in the report. If the file with data used to create a report in Power BI is overwritten, but it contains the same set of tables but with different values, can it be used and read data from the file and update the values in the report?
The Power Query editor is very powerful and should be able to import your data as you want but we'll need a little more to go on than just the source data. We would also need what you want to end up with.
Incremental load is part of Power BI Premium but not sure if that is out yet. Otherwise, your data would be overwritten with the new data.