Forum Discussion

fabiopaturzo's avatar
fabiopaturzo
Helper I
3 years ago
Solved

Import data from an excel file and disconnect it

Hi,

I would like to import data from an Excel file create a new table but the disconnect the excel file.

Thank you

Fabio

Need Help
  • latimeria's avatar
    latimeria
    3 years ago

    Hi fabiopaturzo ,

    Copy the table in Excel.

    In PowerBi, click on "Enter Data", then click on the cell and paste your data.

    You can then use PowedrQuery to transform your data.

    Hope this help.

3 Replies

  • latimeria's avatar
    latimeria
    Solution Specialist
    3 years ago

    Hi fabiopaturzo ,

    Copy the table in Excel.

    In PowerBi, click on "Enter Data", then click on the cell and paste your data.

    You can then use PowedrQuery to transform your data.

    Hope this help.

  • Mycall65's avatar
    Mycall65
    Frequent Visitor
    1 year ago

    This only works when there are fewer than 3000 cells.
    I have 1 file, 3 columns and it only allows me to copy 1000 records.

     

    So, I had to import the sheet as Excel and now I want to disconnect it.

     

    How to do that?