cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mtozero
Helper I
Helper I

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
lndnbrg
Resolver III
Resolver III

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?

View solution in original post

v-yuezhe-msft
Microsoft
Microsoft

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

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft
Microsoft

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

View solution in original post

lndnbrg
Resolver III
Resolver III

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?

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!