Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi! Need your help with DAX troubleshooting. Right now, I am clueless.
So, in Analysis Services I have used the Additonal Connection Parameters to add CUSTOMDATA(), where I want to pass a JSON list of values.
This does not work, and I get the following error:
A table expression for the argument was expected, but a string or numeric expression was used
When I try to troubleshoot this and work around it; i use the following with no issues at all - this works fine.
EVALUATE FILTER ('v_pact_d_reseller_customer', 'v_pact_d_reseller_customer'[Id] IN {20087,20088,20089} )
But when I try this, it does not work.
EVALUATE FILTER ('v_pact_d_reseller_customer', 'v_pact_d_reseller_customer'[Id] IN CUSTOMDATA() )
From my perspective, they should return the same values. What am I doing wrong?
Thanks!
Hi @Anonymous ,
As stated in this article, the CustomData feature only works for models that lie in Azure Analysis Services, and it only works in Connect live mode. Unlike users and roles, the Custom data feature can't be set inside a .pbix file.
Best regards,
Yuliana Gu
Hi @v-yulgu-msft, and thanks for your answer. I am using Azure AS and Live Connection - sorry for not mentioning that. As you can see from the screenshot, I am trying to set it in SQL Server Management Studio.
Any solution in sight ? I'm strugeling with this as well
User | Count |
---|---|
76 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |