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 is simple excel with two columns and few hundred rows...
- 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
2 Replies
- lndnbrg
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-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