Forum Discussion
Set a Summarized Table as Featured Table
Hi
I have created a summary table in my Power BI data model using the DAX Summarize fucntion.
I now want to set this summary table as a Featured Table (so I can connect to it from Excel).
I have selected my Row Label but I am unable to select a Key column to complete the process.
I am able to create a Featured Table from the tables loaded into the data model using M Query - just not my "virtual" table.
I can't see anything in the documentation to indicate that this is not allowed. Has anyone come across this before?
Thanks
5 Replies
Thanks for the response. Yes, I had seen this page - but it doesnt address my issue (as far as I can see).
Sorry about that. I too tried, didn't succeed. Shall explore
hi Jase68
Are you expecting to groupby a table in Power Query, which is similar to SUMMARIZE in DAX?
https://learn.microsoft.com/en-us/power-query/group-by
Hi FreemanZ
Thank you for the response.
No, I was expecting to find a way to set my summary table as a feature table and I dont understad why I cannot.
If the answer is it's not possible to set a (DAX driven) SUMMARIZE table as a feature table then yes, I guess that I would need to understand how to recreate my table using groupby in Power Query instead- but I'd like to avoid that route if I can.
Thanks.
