Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |