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,
What is the best way to offload Measure calculation to custom SQL query limited on start and end date? My data is access via DirectQuery connected to PostgreSQL.
I am trying to calculate the median (50th percentile) of large data set with many millions of rows and would like to do that on SQL server, not in PowerBI.
Found the possible solution here - https://www.youtube.com/watch?v=iiNDq2VrZPY , but it does not looks like 100%, what I need.
Best regards,
Martynas
Solved! Go to Solution.
Hi @martynas ,
Based on your description, do you want to pass the slicer value to the SQL query statement? Complete the calculation in SQL?
Refer to
power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters
pass-parameters-to-sql-queries
You can also try to use SSAS to connect live with powerbi.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@martynas , In case of the direct query you can record the queries and use that to fine-tune it your need
https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/
Thank you for the suggestion. My question is a bit different - how can I perform SQL query to calculate measure value? I.e. select avg(time) from table where date between ('2020-01-01','2020-01-31')?
@martynas , when creating a connection you have the option to give the query Advance, there you can add qyery ?
Yes, that would be possible, but how do I pass the start and end date parameters from slicer in report?
Hi @martynas ,
Based on your description, do you want to pass the slicer value to the SQL query statement? Complete the calculation in SQL?
Refer to
power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters
pass-parameters-to-sql-queries
You can also try to use SSAS to connect live with powerbi.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |