Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a large excel database, with plain rows and colums. Columns are with headings. not all rows are filled.
when I import the excel file, I receive the following message:
the following excel workbook does not contain any queries or model to import (then the file location is mentioned)
I also tried to solve this by format the data as a table but the same error occured.
Does anyone know what im doing wrong?
thanks!
Hello
You can also try ZetExcel
Importing is for bringing an existing Power Pivot data model from Excel into Power BI. If you are only trying to bring in standard sheets and tables from an Excel workbook, you should use the query builder to connect to the file.
Proud to be a Super User!
If you've already setup the Data Model in Excel you can Import it
File => Import => Excel Workbook Contents
This will actually bring in your Data Model AND your PowerView Sheets if any
However some visuals will not display as they are not supported - just for example a Pie Chart with Vertical Multiples
(I wish they would add support for this soon) or a Map with satellite background which I created an Idea for here over a year ago
Anyway if you are just starting to build your Data Model and Excel is just a data source
PBI Home tab => click Get Data => select Excel => choose your file
I have a large database with data that I want to import into Excel. it are only columns and rows, headers included.
when I import I receive the message:
The following Excel workbook does not contain any Queries or Model to import: (then file location is mentioned)
probably a very stupid question, but what am I doing wrong?
Proud to be a Super User!