Forum Discussion
Helper IPower BI presenting 0 data from excel sheet
Yes will do, thanks for your help
I had to take the query back to the source, It seems there was an issue when changing the format of a column within the query editor. This changed the value of that column to "0" When trying to change back the values remained as zero or every column format automatically changed to text which was frustrating and still upon format changing again from text to whole or decimal number the value returned "0"
The only way I could get this to work was to go back into the query ediot and remove queries except the source and start again - luckily the visuals and dashboards where already in place so it was not to time comsuming - although a solution any additional help on this would be awesome guys
Calum
Helper IThanks for the suggestion - tried and no joy
i seem to have made a change and for some reason data was presenting in text format - I'm changing it all back now, very strange and long winded
- Calumc12
Yes - I took the query back to source
- Icey
Community Support
Hi Calumc12 ,
Glad to hear that. Please accept your reply as the solution. Your contribution is highly appreciated.😜
Best Regards,
Icey
- Calumc12
Yes will do, thanks for your help
I had to take the query back to the source, It seems there was an issue when changing the format of a column within the query editor. This changed the value of that column to "0" When trying to change back the values remained as zero or every column format automatically changed to text which was frustrating and still upon format changing again from text to whole or decimal number the value returned "0"
The only way I could get this to work was to go back into the query ediot and remove queries except the source and start again - luckily the visuals and dashboards where already in place so it was not to time comsuming - although a solution any additional help on this would be awesome guys
Calum