Import Excel data to power Bi service

[Mtozero]

I am not able to import the excel data into power BI service(free version...trial version has expired).  Getting the message as We couldn't find any data formatted as a table. 

My data source is simple excel with two columns and few hundred rows...

[lndnbrg · Accepted solution]

There is a way in Excel to tell Excel, that your two columns are a „table“ - instead of just a bunch of cells.

Check this: https://support.office.com/en-us/article/Create-or-delete-an-Excel-table-e81aa349-b006-4f8a-9806-5af...

Does that fix it for you?

[v-yuezhe-msft · Accepted solution]

@Mtozero,

Another way is directly to connect to the Excel file in Power BI Desktop, create reports in Power BI Desktop and publish reports to Power BI Service.


Regards,
Lydia

[lndnbrg · Accepted solution]

There is a way in Excel to tell Excel, that your two columns are a „table“ - instead of just a bunch of cells.

Check this: https://support.office.com/en-us/article/Create-or-delete-an-Excel-table-e81aa349-b006-4f8a-9806-5af...

Does that fix it for you?