Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have tree table visualizations based on three querys. The visualizations contain the same column names, but come from three different data sources (Sharepoint, SQL Server, and Excel), hence the three different querys. I now want to test to see if values in the Sharepoint table (id field) are in the SQL Sever table visualization (id Field when the amount field is less than 6) and then ido the same task against the Excel tabel visualization. In essence, I want to select the values from the SharePoint table visualization when the corresponding field value is also in the SQL Server field.
Select *
from SharePoint visualization
where id in (
select id
from SQL Server visualization
where amount < 6)
Any ideas on how to do this?
Sincerely,
Peter
Solved! Go to Solution.
Hi @pkoel-asb ,
As mentioned by @trebgatte , after you connect the data, you can use Merge Queries to achieve the results you want:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pkoel-asb ,
As mentioned by @trebgatte , after you connect the data, you can use Merge Queries to achieve the results you want:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have to do this much earlier in the process since Visuals only display the final results.
In the Power Query Editor, (Transform Data on the new Ribbon), you can connect and query each source individually.
I hope this helps!
--Treb
Check out my Power BI blog posts at https://marqueeinsights.com
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
55 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |