D365 online query for only a number of entities

[Anonymous]

Hi

I imported numbers from D365 into Power BI (and Excel).

But I only get one entity. But we have more than 50 entities. But the query will only list the entity which I have as standard entity in D365 settings.

Our guy from IT that it was not possible to get more than one entity via D365query into Power BI.

I'm somehow not sure if this is really true. We are for sure not the only company who has more than one entity..

Anybody any idea on this?

Thanks!

Patricia

[v-jingzhang]

Hi @Anonymous 

It should be possible to connect to more than one D365 entity in Power BI Desktop. Please refer to this document: Use Power BI with Microsoft Dynamics 365: Use Power BI Desktop to connect directly to your Microsoft Dynamics 365 (online) instance

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.