PQ or PP for joins??

Anything related to PowerPivot and DAX Formuale
mitchandsuzy
Posts: 20
Joined: Tue Nov 17, 2015 4:00 pm

PQ or PP for joins??

Postby mitchandsuzy » Mon May 07, 2018 1:49 pm

Hi All,

As I sit here waiting for my Power pivot data refresh to update I am wondering if I should really be doing all the data manipulation in Power Query.

I created several tables to translate keys to the full description in PP eg 2074 ---> Ku-ring-gai Council etc and I use the relationships to provide data in the reports created via the pivot tables.

I have 18 tables some with 140,000 rows all index tables less than 100 rows.

(40 mins and still updating!)

Does anyone have an opinion regarding this??

Kind Regards
Suzy.

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests

cron