Forum Discussion
import excel to power BI
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!
5 Replies
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?
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
Hello
You can also try ZetExcel
