Forum Discussion
EvanBeiser
10 years agoFrequent Visitor
Importing Account Numbers That Start with Zero
Hello all, I am very new to Power BI and already finding some small issues that I can not overcome. I have uploaded two data sets to my report, one from excel and the other from an oracle databas...
- 10 years ago
On the "Home" tab of the Query Editor, try selecting the column and changing the "Data Type" to "Text" versus, probably "Whole Number". The "Data Type" setting can be found in the "Transform" section of the ribbon on the "Home" tab.
Greg_Deckler
10 years agoCommunity Champion
On the "Home" tab of the Query Editor, try selecting the column and changing the "Data Type" to "Text" versus, probably "Whole Number". The "Data Type" setting can be found in the "Transform" section of the ribbon on the "Home" tab.