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.
How can we limited data from a huge table reside in SQL Servere database?
We used WHERE clause in SQL Server. Do we have similar command in Power BI while pulling the required data?
Thanks in advance.
Solved! Go to Solution.
Hi @tap_ks,
In your scenario, you should be able to import all the tables one by one, by running corresponding native database queries against the same database each time.
Regards
I'm working on the report, trying to add a measure. The dashboard reference is to the data, the data set is the Audit Log data from the Office admin portal pulling dashboard views.
I'm looking for a measure that will count the users that exceeded a count of 50 views on the dataset. I have a metric that counts the views and displaying that fine on the report. Now I'm looking for a way to count the number of users who have >50 views. I can build a bar chart of the users and their views and filter that for >50, but I'm looking for a way to count them and show that count on a card visual.
You can use custom SQL including your where. Just after choosing SQL server from Get Data, on the same screen as your server/database attributes, click the Advanced options and put your SQL into the SQL statement field.
I need to pull from multiple tables e.g. from Customer, Orders, Items, Products tables separately. Then wants to buils a relationship.
How to do so?
Thanks in advance.
Hi @tap_ks,
In your scenario, you should be able to import all the tables one by one, by running corresponding native database queries against the same database each time.
Regards
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |