Forum Discussion
Transform Data Apply changes all number cells to zero
Hi,
New to Power Bi so appolgies if this is in the wrong section
I have a connection via web API which populates data within a a Power Query as below
The columns i'm primerily interested in are data.data.data and data.categories
When i click on Apply and close to get back to teh desktop to create my visualization and select Table view to check my data, all my data.data.data cells are zero, see below
I have no idea where i'm going wrong. I have tried changing the data type to decimal, whole number etc but that makes no difference.
Can anyone shed any light on how to resolve this please. TIA
stand down Internet.. all fixed Thanks.
Turns out its an issue with the API and Cached data... cleared the Cache and we then started getting Null return of data... that then allowed us to find teh issue in teh API.. thats been fixed and now we have the data we are expecting.
2 Replies
stand down Internet.. all fixed Thanks.
Turns out its an issue with the API and Cached data... cleared the Cache and we then started getting Null return of data... that then allowed us to find teh issue in teh API.. thats been fixed and now we have the data we are expecting.
Pigsfoot , Power Query and the DAX table view may have different sorting. Just check or open the filter in the data pane to check distinct values.
If you feel they are wrong, try reloading using refresh and see if any errors appear.
