CODEWITHSUNDEEP
powerbidaxdata-modeling
James Khan
James Khan

Reputation: 841

Power BI - Merging multiple customer tables

enter image description here

Connection Type: Direct Query to multiple sources so limited DAX available especially in Power Query load.

Data Model Query: The Data model is not a perfect star schema but there is an attempt to separate tables into business processes and lookup tables. There are probably a few issues to discuss the current data model. I only have 1 question at this time.

My current goal is to generate a single summarised customer table to replace the current two tables that have some measure I need like the number of app customers, a number of total customers, date customer first accessed app etc.

So I cannot merge the 2 customer tables and add calculated columns and measures at the import stage as power bi does not support or allow it and sql is out as I am using direct query. My plan is to create a summarised customer table using DAX summarise function on front end visual page, that has only the app customers and then measures like the total number of customers etc. Is this best practice or is there a better way of approaching this? Understand you would ideally do in sql, or power query but in these circumstances, I think this is the best way but wanted a second view.

Upvotes: 1

Views: 462

Answers (1)

Treb Gatte
Treb Gatte

Reputation: 9

Is there a reason to use Direct Query over Import? If you are in Import mode, you can easily Append the two client tables together in PowerQuery.

Treb Gatte, Power BI MVP

Upvotes: 1

Related Questions