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
Suzy
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