Forum Discussion

F_Rehman2007's avatar
F_Rehman2007
New Member
7 years ago

Certain Data Missing from Excel Source

 Hello,   I am working on a Power BI Dashboard where a single table Excel spreadsheet is the source of the data. This underlying spreadsheet has a list of subjects with various columns related to d...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi F_Rehman2007,

 

Are these data imported into Power BI? Can you see them in the data tab? Though they don't show up in the visuals, that may not relate to the data source.

Certain_Data_Missing_from_Excel_Source

 

 

Best Regards,

Dale

F_Rehman2007's avatar
F_Rehman2007
New Member
7 years ago

The row count in the Data Tab (Power BI) = the row count in the Table in the Excel Source.

 

As I said I am working on a single page, but the Report itself contains several pages. When I look at the Relationships section, the Tables in the other pages are linked to the single Table being used in the page I am working on. So I don't know if they are somehow impacting the Table in my page.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi F_Rehman2007,

     

    Can you share the file or a dummy one?

    The other tables (pages) could impact the result if you involve them in the visuals, filters or slicers. But we can't find out more without data.

     

    Best Regards,

    Dale