Forum Discussion
Mtozero
Helper I
Helper IImport 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 ...
- 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-5af9df0ac664
Does that fix it for you? 
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
Resolver III
Resolver IIIThere 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-5af9df0ac664
Does that fix it for you?
Check this: https://support.office.com/en-us/article/Create-or-delete-an-Excel-table-e81aa349-b006-4f8a-9806-5af9df0ac664
Does that fix it for you?