Hi Arun,
I can confirm that the OOB dimensions are not available when using the AA plug-in in Power BI as we have checked with users who don't have any restrictions in terms of access levels & who works on other accounts.
2) We've been working trying to figure out the solution for users who don't have much technical expertise & can easily use the plug-in or the 'Publish the workbook' using RB query. The first option is fairly easy but due the limitations, we can't do much.
- Even with PRO license, if the Admin of your organization have put some restrictions in terms of service like in our case, we can't publish the work book. So users need to get in touch with their IT teams who manages the Power BI account to open the services & this solution can be used.
Further to this, we are now analyzing if we can schedule the workbook which would automatically also refresh the data in Power BI. With that being said, there might be further limitations like interms of number of queries & the breakdown, but it's good to create smaller dashboards using the RB query.
Thanks
M