Forum Discussion
Multiple tab dashboard like multi tab reports
Community AdminI'm assuming you're using the Power BI Desktop here?
When you hit refresh it's just looking for new data in the table/range you initially imported. You'll need to create a second connection to that workbook for the data on the second sheet. You can use the Query Editor to merge or append the two sheets together if you want it to appear as a single table in Power BI, and you can use the Query Editor to load them dynamically as well if you don't know how many sheets will have data in the future.
HTH
Will
Hi,
Yes I am using Power Bi Desktop. When I try to create a second connection I still dont have my second page show up as an option no matter how I query it. It seems to keep using the first connection and only showing the one tab.
Not sure where to go from here.
Question ? In the event I want to take an exiting reporting and reaim it to a new excel sheet without breaking all the work I did in the report is this supported. I did a test earlier and it seems even when I use a copy of the original excel sheet, it will break.
Thanks