Forum Discussion

Uspace87's avatar
Uspace87
Resolver III
2 years ago

Run Dax query in Fabric Notebook

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 ...
Need Help
Uspace87's avatar
Uspace87
Resolver III
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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

  • Uspace87's avatar
    Uspace87
    Resolver III
    2 years ago

    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