Forum Discussion
Power Query Editor Decimal Issue on Text Field
JoyCornerstone,
Please ensure that you have set the data type of the numbers to Text correctly in Excel. I make a test using your sample data by directly coping and pasting them to Excel as below.
When I disable Type of detection option in Power BI Desktop, the data come in as follows.
When I enable the type detection option in Power BI Desktop, the job numbers will be automatically changed to decimal number in Power BI Desktop query editor. I then delete the change type step in Query Editor, the job numbers are as below.
Regards,
LydiaJust wanted to leave this here for others how might find it later. It took some work, but I was able to change my Excel columns to Text using the TEXT function in Excel.
Once you have linked them into PowerBi, the only way to get them to really be Text is to use the TEXT function in Excel. Then they will all read into the PowerBI successfully.
Just wanted to leave this here for others how might find it later. It took some work, but I was able to change my Excel columns to Text using the TEXT function in Excel.
Once you have linked them into PowerBi, the only way to get them to really be Text is to use the TEXT function in Excel. Then they will all read into the PowerBI successfully.
It's an old post. But I had the same issue and seemed tocome up with a better solution. Add a column using PQuery function Number.To.Text where one can define a format of the text and after convert it back to number.