The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi,When working with the new feature 'Field Parameters' then DAX function Columnstatics() is not working.
It produces composite key error.
When using COLUMNSTATICS() function in Power BI, it should be in a calculated virtual table, not as a physically calculated table directly. See: New DAX Function COLUMNSTATISTICS – Overview
In addition, about field parameters table, it is shown as a multidimensional model table in Power BI, please refer:
DAXMD and DefaultMembers
Best Regards,Community Support Team _ Yingjie Li
Hi,Thank you for your answer Yingjie Li.
Here are more details regarding the error.
I was using COLUMNSTATISTICS function to create a virtual table in DAX Studio.
When using COLUMNSTATISTICS function with the new field parameters table applied, I get a composite key error.
However, I can work with field parameters table in DAX Studio, if I specify the columns correctly. I get the columns and fields accordingly.
Then I tried using COLUMNSTATISTICS function on a data model, that does not have field parameters applied, then it works without an error.
All the best,
Same for us.
We are building a cloud software and embedding reports from Power BI.
We want to run the 'execute queries' with REST API and use COLUMNSTATISTICS() to get a list of all tables and columns but we face the same issue.
Without field patameters in the dataset, it works. Include field parameters we get the same error as mentioned...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.