cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mtozero Regular Visitor
Regular Visitor

Import Excel data to power Bi service

 

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
lndnbrg Member
Member

Re: Import Excel data to power Bi service

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?
Moderator v-yuezhe-msft
Moderator

Re: Import Excel data to power Bi service

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
lndnbrg Member
Member

Re: Import Excel data to power Bi service

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?
Moderator v-yuezhe-msft
Moderator

Re: Import Excel data to power Bi service

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.