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.
I have Power BI Desktop connected to an local MS SQL server. Most of the data is pulling file, however some feilding in some columns is missing.
For example: In my SQL database I have the following data:
But when I look in Power BI I get this:
Other data appears to be queried correctly
Solved! Go to Solution.
@aaronbest_ Few ways you can check if there's an issue,
1. go to data view in power bi desktop by clicking on Data view on left hand side and check all data is there or not
2. Check data in table visual and ensure you have Don't summarize for all the fields you've dropped on table visual
3. Ensure correct data type has been applied in power bi desktop to each columns
4. Query SQL Server data source explicitly for those columns by typing in sql query
@aaronbest_ Few ways you can check if there's an issue,
1. go to data view in power bi desktop by clicking on Data view on left hand side and check all data is there or not
2. Check data in table visual and ensure you have Don't summarize for all the fields you've dropped on table visual
3. Ensure correct data type has been applied in power bi desktop to each columns
4. Query SQL Server data source explicitly for those columns by typing in sql query
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |