Forum Discussion

fabiopaturzo's avatar
fabiopaturzo
Icon for Helper I rankHelper 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.

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?