Forum Discussion

ggertz's avatar
ggertz
Advocate I
10 years ago

worksheets

Hello All

 

Help appreciated 

I have an excel workbook with a bunch of tabs

After I import it to PBI I only see one data set...

Any guidance?

 

Thanks

G

 

2 Replies

  • djnww's avatar
    djnww
    Impactful Individual
    10 years ago
    It sounds like you are uploading onto PowerBI on the cloud rather than using Power BI Desktop. Is this correct ? All Excel data that is uploaded onto the web version of PowerBI needs to be formatted as a table in order to be recognised.
  • Tsanka's avatar
    Tsanka
    Kudo Collector
    10 years ago

    As far as I know, when you import an Excel file into PowerBI desktop, the datamodel of the Excel file is imported.

     

    How many queries are there in your Excel datamodel?