Forum

Power BI Desktop an...
 
Notifications
Clear all

Power BI Desktop and existing Excel/PP/PQ files

2 Posts
2 Users
0 Reactions
50 Views
(@mitchandsuzy)
Posts: 1
New Member
Topic starter
 

Hi Everyone,

I have and existing set of workbooks that I have "tidied" using PQ (Power Query) and I have analysed using PP

(Power-Pivot).

I know I can transfer this to PBI but I have never managed to do it properly.  Is this covered in your course please?

I am enjoying the course so far - I finally understand why my relationships were not active in PP - I figured it was something along those lines and so I separated as much as I could to get the relationships I needed.

Kind Regards

SuzySmile

 
Posted : 23/02/2017 2:08 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Suzanne,

Yes, you can import Excel workbooks containing Power Query queries and Power Pivot models.

From Power BI desktop File tab (to the left of the Home tab) > Import > Excel Workbook:

 

It will bring in all of your queries, data and Power Pivot model complete with relationships and measures.

Mynda

 
Posted : 23/02/2017 11:27 pm
Share: