Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Issue since recent download: Text column in Query Setting is trying to convert data to numbers

Across mutliple reports, I'm receiving a data format error ever since the recent download upgrade. It is a text column in the query, and when selecting the "error" it's stating "We couldn't convert to a number." This is a text column so should not be converting. Several lines of data are showing errors due to this across multiple reports.

 

medepke_0-1644504909137.png

medepke_1-1644504927621.png

 

Status: Investigating

Hi @Anonymous 

 

May I know what’s the data source and the connection mode of this report? If it is Import mode, could you please provide a link of a sample pbix file containing this error? In addition, please let me know the data type of this column in the data source and the version of your Power BI Desktop. You can check the version info by Help> About> version in Desktop. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @Anonymous 

 

May I know what’s the data source and the connection mode of this report? If it is Import mode, could you please provide a link of a sample pbix file containing this error? In addition, please let me know the data type of this column in the data source and the version of your Power BI Desktop. You can check the version info by Help> About> version in Desktop. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun