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

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,016 guests
Please welcome our newest community members: