Showing results for 
Search instead for 
Did you mean: 
sy9th Visitor

Dashboard on SharePoint

Hello everyone,


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?



Super User
Super User

Re: Dashboard on SharePoint

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.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,844)