Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
Table.NestedJoin in Azure Analysis Services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is there a workaround?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2020-11-20T23:30:34.787+00:00 Hello @James H. Robinson ,
Thanks for the ask and welcome to the forum .
As far the documents goes it looks like Table.NestedJoin should work with AAS , Can you share more details on the error please . That wil help us dig more into this issue .Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-11-30T20:48:59.017+00:00 Hello ,
We have not heard back from you on this and was just following up ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-12-02T20:00:32.137+00:00 Hello ,
We have not heard back from you on this yet and was just following up ,if the issue is resolved .
In case if you have a resolution we request you to share that with the community .Thanks
Himanshu
Sign in to comment
Sign in to answer