Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Hint for new users - Importing Excel data in table format

Here is something I just learned that may benefit other new users like me.   Specifically: When importing Excel data that has been formatted as a Table, be sure to delete columns that have no dat...
  • MFelix's avatar
    8 years ago

    Hi Anonymous,

     

    If on Excel you make you information as table and then select the table instead of the worksheet this will not add the addtional columns you are refering.

     

    Be aware that when you upload an Excel file to PBI there are two icons one for pages other for tables.

     

    Regards,

    MFelix