Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
So I'm trying create a direct query model against my SQL database but there are 3 tables that I want appended to each other as one table first. Say I don't have access to our DB admin to just combine them at the source is it less efficient to run a Direct query against a DB with your own SQL statement?
An example below:
I know for example running your own SQL statement for import prevents any further query folding for additional transformations you may do in Power Query but how badly does this affect direct query?
Would you advise another method of doing this via direct query? Should I setup my direct query tables separately and create a union table via DAX?
Kind regards,
Mike
Solved! Go to Solution.
@Mike282 , Create this as a view on database and try to use that
@Mike282 , Create this as a view on database and try to use that
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |