cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erikcappendijk Frequent Visitor
Frequent Visitor

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 5
Highlighted
erikcappendijk Frequent Visitor
Frequent Visitor

importing data from excel into POWER BI

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? 

Super User
Super User

Re: import excel to power BI

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.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Super User
Super User

Re: importing data from excel into POWER BI

Duplicate thread


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Super User
Super User

Re: import excel to power BI

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9583053-aerial-satellite-photo-ma...

 

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

 

jeremygore Frequent Visitor
Frequent Visitor

Re: import excel to power BI

 Hello

You can also try ZetExcel