Not getting all groups from the Power Bi desktop AAD connector

[TexasBI]

Please help.

I have connected my AAD to Power BI Desktop using the AAD connector. I then selected the "group" table to try and see all of the groups inthe AAD. I have 100s of groups but for some reason I only got back 8 groups. 

Any idea as to why this could be???

[v-yuta-msft]

@TexasBI ,

Power bi currently doesn't have AAD connector, please see this idea. Could you please clairfy how do you connect to AAD in power bi desktop?

Regards,

Jimmy Tao

[TexasBI]

I needed the AAD connection to build Dynamic Row Level security without having to use the RLS from the service and manage the end users access leveraging Groups in the AAD. I built a logic app that handles api calls using the microsoft graph api and am able to pull all the necessary tables needed to find all my users, groups, and members in those groups.