Import data from an excel file and disconnect it

[fabiopaturzo]

Hi,

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

Thank you

Fabio

[Mycall65]

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?

[fabiopaturzo]

Hi @latimeria ,

Could you attach some screen shot of the steps?

Thank you

Fabio

[latimeria · Accepted solution]

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.