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

[winner-zlx]

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.

 
 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.

 

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_CD	ANP USD	Gross VONB USD
a	0	0
b	0
c	1	0
d	2	0
e	3	4
f	4	0
g	5	5
h	0	6
i	0
j	0	0
k	6	9
l	7
m	8	23
n	9	11

source A:

Column1

a

a

b

c

d

e

f

g

h

i

j

k

l

m

n

[v-yetao1-msft]

Hi @winner-zlx 

What is your test Desktop version and Service version ?

Best Regards,
Community Support Team _ Ailsa Tao

[winner-zlx]

Hi Ailsa,

my service version: 13.0.19491.58

desktop: 2.108.997.0 64-bit (August 2022)

Thanks.

Best Regards,

[v-yetao1-msft]

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]

Hi@v-yetao1-msft ,

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