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.
All values show in a column display in power query. Same values show (correctly) in the table view.
Pulling the column into a visual shows blanks for most, and the table view show null.
Any assistance greatly appreciated
The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
Yes,
Request data via sql statement from oracle database.
Query displays an estimated account value and fees for. example below:
Acct Name | Estimated val | Fee amt |
Mets | 0 | null |
Yourk | 155000 | 3000 |
Guts | 0 | null |
Mike | 818000 | 2125 |
When the above is pulled into a table or Matrix visual the results are below.
Acct Name | Estimated val | Fee amt |
Mets | 0 | |
Yourk | 155000 | |
Guts | 0 | |
Mike | 818000 | 2125 |
No Measures or added columns for the above data. Please note, the Fee amt was determined by calculation before exporting to power bi.
The table is connected to a date table dy date received (not shown in this example).
Thanks for taking a look.
~Kd
Hi @Anonymous ,
Please check if this is caused by the Date table. For example, filter the data with date slicer.
It will be best to provide some screenshots. Please cover sensitive information.
Best Regards,
Icey
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |