Forum Discussion

ozgurya's avatar
ozgurya
New Member
6 months ago
Solved

Navigator Screen Issue

Hi, I'm trying to add a new table to my Power BI report. I've added the new table to the source Excel file, but it's not appearing in the Power BI Navigator screen. Therefore, I'm unable to import it...
General Comment
Need Help
  • v-tejrama's avatar
    v-tejrama
    5 months ago

    Hi ozgurya ,


    Thank you for reaching out. When you add a new worksheet to an existing Excel file, Power BI may not automatically recognize the structural changes, especially if the connection was previously established. Refreshing the report often does not update the metadata captured during the initial connection. To address this, please go to Data Source Settings, clear the permissions for the Excel file, close Power BI Desktop, then reopen it and reconnect to the file.

     

    This process forces Power BI to re-read the workbook structure, and the new sheet should appear in the Navigator window. Ensure the Excel file is saved and closed before reconnecting. If you intend to import the new data as a table, verify that it is formatted as an official Excel table rather than a cell range. Following these steps should make the new worksheet visible for import.

    Thank you.