cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to convert a value to the data type requested for table

Hi everyone,
 
I am using a composite model -- local source (A) and power bi dataset with DirectQuery mode (B). For source B I have created the following measure.

 

m1 = SUM('Table (2)'[Gross VONB USD]) 
m2 = SUM('Table (2)'[ANP USD]) 
m3 = DIVIDE( [m1] ,[m2] , "n/a") 

 

Then the relationship is created in the composite model.

 winnerzlx_1-1.png
 If I include both columns of source A (i.e. Column1), columns of source B and measure m3 in the visual, it will report the following error.

 winnerzlx_2-2.png

This error occurs on Power BI Desktop and Power BI Service. I know a workaround is to recreate a new measure in the composite model to replace m3, but I would like to know if this is a bug and when it will be fixed.

 

Here is my sample data.

source B:

PLAN_CDANP USDGross VONB USD
a00
b0 
c10
d20
e34
f40
g55
h06
i0 
j00
k69
l7 
m823
n911

 

source A:

Column1
a
a
b
c
d
e
f
g
h
i
j
k
l
m
n
Status: Accepted

Hi @winner-zlx 

I have submitted it to ICM , the ID is 353248649 .If there is news, I will come back to update .

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
Ailsa-msft
Community Support
Status changed to: Needs Info

Hi @winner-zlx 

What is your test Desktop version and Service version ?

 

Best Regards,
Community Support Team _ Ailsa Tao

winner-zlx
Regular Visitor

Hi Ailsa,

 

my service version: 13.0.19491.58

desktop: 2.108.997.0 64-bit (August 2022)

 

Thanks.

 

Best Regards,

Ailsa-msft
Community Support
Status changed to: Accepted

Hi @winner-zlx 

I have submitted it to ICM , the ID is 353248649 .If there is news, I will come back to update .

 

Best Regards,
Community Support Team _ Ailsa Tao

katharine_kk
New Member

Hi@Ailsa-msft ,

 

I also encountered the same problem, has this BUG been fixed? Any updates?