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.
Hello,
I have following issue:
Is in M a possibility to wirte a SQL statement with a "under-Select ", e.g.
Select Databasemouse.Animal from Databasemouse
where (Select (Databasemouse.legs + Databasemouse.Arm)>2 from Databasemouse)
Databasemouse:
Animal | Enemy | Legs | Arm |
Mouse | Snake | 2 | 2 |
Dog | Lion | 0 | 1 |
Solved! Go to Solution.
Hi, @Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse
where (Databasemouse.legs + Databasemouse.Arm)>2
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse
where (Databasemouse.legs + Databasemouse.Arm)>2
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Do5779 Do you want to convert a SQL code to M or just want to use SQL statement to load data into Power Query?
thank you for your respone. I only want to execute a SQL statement (advanced editor) with a "where select"-statement and I don't know why it isn't working.
@Do5779 If you are thinking about querying the table of an M code using SQL then that can't be done, if you are trying to query the Database using SQL then what is the error that you are getting?
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |