We couldn't import data from OneDrive - Personal #Part 2

[tiyoskaeys]

Hi, is it possible to Connect data excel without have to manual open excel and presss Ctrl + T, how to solved this?

Because this means Datasets "Refresh now" will not work, right?

 

We couldn't find any data formatted as a table

To import from Excel into the Power BI service, you need to format the data as a table. Select all the data you want in the table and press Ctrl + T

[v-lili6-msft]

Hi

The online version is only for end users that want basic capability to browse through a dataset,

Power BI Online only reads Excel data that have been converted to Tables (CTRL + T). Power BI Online will read and understand any table relationships that you have created in Excel as well.

Regards,

Lin

[tiyoskaeys]

Hi, 

Yes, as far as I go the only current solutions is using Ctrl + T and keep the format as it.

Thanks