Forum Discussion
Data missing between query and report
So I actually just stumbled upon the answer. For some reason, the other four columns we look at were all being identified by Power BI as data type Decimal Number, while the Client Unpaid column was being identified as data type Whole Number. I haven't double checked yet, but I believe any amount that had pennies was being excluded.
Thanks for your time,
Seth
Hi Anonymous,
It seems you create a measure of "client unpaid". Could you please share the formula? If I am wrong, how does the data look like in the data view?
Best Regards!
Dale
Hi Dale,
No, it is not a measure, simply a column. When the "Net Billed" column has a value, "Client Unpaid" should have something there as well, even if it is only 0.
The first screenshot below shows another instance of the data not being there, this time in the Data View. The second screenshot is in the Query Editor, drilled down to the same place.
And this is what I find confusing. The cell is populated when viewed in the Query Editor, so we know the data is being properly loaded into Power BI Desktop. But then it's suddenly missing in the Data View and the Visual View??? The only steps taken in the Query Editor are unreleated to this particular column.
Furthermore, as you can see in the first set of screenshots I uploaded, there are plenty of values in the Client Unpaid column. It almost seems as if the missing data is completely random.
This will completely ruin the project if we cannot figure out why this is happening and so far there are no indicators.
So I actually just stumbled upon the answer. For some reason, the other four columns we look at were all being identified by Power BI as data type Decimal Number, while the Client Unpaid column was being identified as data type Whole Number. I haven't double checked yet, but I believe any amount that had pennies was being excluded.
Thanks for your time,
Seth