Forum Discussion
compare columns in two different tables
Hello, I need to implement SQL queries in Power BI as our's is a migration project. There are so many join conditions in the SQL. What I am doing is, pulling all the required columns from all the ta...
daXtreme
Solution Sage
Solution Sage
In Power BI there's a mashup engine. It's called Power Query. This lets you pull data, however messy, from any source and massage it into a form that Power BI wants to work with (think: star schema). So, it's not DAX's job to massage data but Power Query. Please therefore use the right tool for the job. DAX is an analytical engine, not mashup.
By the way, SQL is for querying data in (mostly) normalized form. Star schema is what semantic models like: denormalized form. So, please pull data from your SQL source and make it into a denormalized form, dimensions and fact tables.