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

[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.