Is it possible to view a tab of an excel file on a local sever on a Power BI tab?

[tbobolz]

We have an excel file that is manually put together due to system limitation. Another user creates a "report" by manually populating cells and creating a simple table format. There's no data behind it. Is is possible to connect to this excel file and show this excel files tab, kind of like displaying the excel file procuct in print mode but on a tab or visual with in the Power BI dashboard.

Hope that make sense.

Thanks for lookking at my question.   

[christinepayton]

Yeah, you can connect to local Excel files with a gateway. It's better if you can move it to SharePoint Online though, and connect to it there - way easier to schedule refresh on. It's not going to look like it does in Excel, but you can put the data in a table on a tab and people can technically print it if they want to. 

[tbobolz]

Thanks Christine, yes, I'm familar with excel  file connection, however, I was hoping for more of a snapshot of the current format. The data will change and I suspect this would mess up the automation. I'll keep playing with it.

[christinepayton · Accepted solution]

If you use SharePoint, you can embed the sheets/individual tables/whole file in a SharePoint page as well - it's very quick and easy, in case that's an option for you.