Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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

Submitted by Anonymous on ‎02-10-2022 07:01 AM

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

See more ideas labeled with:
1 Comment (1 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎02-10-2022 06:27 PM
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

Idea Statuses