Run Dax query in Fabric Notebook

[Uspace87]

Hi all,

I hope someone can help me :).

I am running a trace on a dataset using Fabric Notebook (Python).

Basically meanwhile the trace is running I refresh the report and I get as a result all the queries that got sent.

I will paste some of the code here with some comments

query1 = final_trace_logs.iloc[0]['Text Data'] (Here I store the dax query into variable query1)

print(query1) (here I print it and it looks good and if I copy paste the result and I run in on dax studio it works)

The next step is where I have problems. I don't undestand why if I paste the query as a string it works, if I pass it as a variable, the code gives me error. can someone help me please?

test = fabric.evaluate_dax( "Validation Test Hive", query1) 

[Anonymous]

Hi @Uspace87 ,

Thanks for using Fabric Community.
I haven't tried it, can you please try like this?

query1 = 'final_trace_logs.iloc[0]['Text Data']'

or 

query1 = "final_trace_logs.iloc[0]['Text Data']"

 
Please let me know if you got any errors?

[Anonymous]

Hello @Uspace87 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[Uspace87]

hi @Anonymous  thank you for your reply but that would not work.

as I mentioned before I do store the the dax code into the variable query1

query1 = final_trace_logs.iloc[0]['Text Data']

[Anonymous]

Hi @Uspace87 ,

Syntax of evaluate_dax - sempy.fabric package | Microsoft Learn
It expects string

For Eg: Read data from semantic models and write data that semantic models can consume - Microsoft Fabric | ...

Can you please check the type(query1) ? I can see it is not a string.

Hope this is helpful. Please let me know incase of further queries

[Uspace87]

Hi @Anonymous  thanks for the replay. as you can see in the output I am printing the dax query and the type of the variable (query) and it's a string but if I pass it as a variable the code does not work, I have to copy and paste the text itself as you did in your example

[Anonymous]

Hi @Uspace87 ,

Can you please share the screenshot for below codes -

query1 = final_trace_logs.iloc[0]['Text Data']
print(query1)

final_trace_logs.iloc[0]['Text Data']

print(type(query1))

 
I can get some more idea of your problem and I can help you out.

[Anonymous]

Hello @Uspace87 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .
Thanks