Expression.Error: We cannot convert a value of type Record to type Text.

[Anonymous]

iam trying to do dynamic M query parameter.

iam using odbc to amazon athena datsource in power desktop.

first iam loading the table by wring the sql query in while importing.

for passing values in parameter , i have  slected one column and added as new query.

Then i created parameter  and passed values from query selectday. the apped the parameterr in the query1.

after igot no syntax errors, but iam getting below error.

Kindly help me with the solution

, 

[v-chenwuz-msft]

Hi @Anonymous ,

The second argument of function Odbc.Query() should be a text than record, which i have highlight in red.

Replace it with:

Odbc.Query("dsn=CocobluData", filterquery)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-chenwuz-msft , i have done that now, the error is gone, but iam not getting data, it is blank, but actualy data is there. Please help me with these. why it it is getting blank, iam loading as import mode , data souce is aws athena, using odbc connectoe in power bi. 

[v-chenwuz-msft]

Hi @Anonymous ,

Can you use SQL statement as text directly with Odbc.Query() to check wether it is right.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try MM in capital case .

In power query, few of them work with a capital case

[Anonymous]

@amitchandak ,Thanks for the reply.

if iam test parameter also iam getting following error

Kindly help me for the solution

[amitchandak]

@Anonymous , But, we discussed about the date in the first update.

for this one can check the type of the parameter, it should be text

[Anonymous]

@amitchandak , Thanks for the quick reply,

First one about date is still loading. we have another where have parameter with text.

we are text type in parameter. but still getting same error.