News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Can't see all enti...

Finance | Project Operations, Human Resources, ...

Answered

Can't see all entities in Power BI from Cloud based F&O

(0) Share

Report

Report

Posted on by Ali1001

15

Hello,

I am using Power BI ODataFeed to connect cloud based F&O but un-able to see all the entities. Any help would be appreciated.

Connection

In F&O there is an entity used SalesTable

When I connect Power BI to F&O and search for SalesTable it doesn't show that entity

any guidance would be appreciated.

Thanks,

Ali

All responses Img

All responses (13)

Answers Img

Answers (2)

Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Glad to be of help :)
Ali1001 15 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Once again thank you so my for your AMAZING help :)
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

If you have multiple legal entities from where you need to fetch , you should do it in this way only. If you have a single legal entity ,you can set the company for the user as I mentioned initially.

Since your question is answered, please mark the useful answer(s) as Verified. This is done by Did this answer your question? > Yes in the reply.
Ali1001 15 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Gunjan,

THANK YOU so much!! It worked. Question Do I need to create separate connections for every entity I need to use in this format? or is the a work around?

REALLY appreciate your help!!!!

Thanks,

Ali
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Ali,

Seems to be a space between cross-companyj= and "true". please remove the space and check again.
Ali1001 15 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Gunjan,

No problem. Still no luck :(. Is there something I'm not doing right?
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Ali,

My mistake. I missed the cross-company=true part in the url. I have updated it now. Please try with this -

xxxxxxxxxx.dynamics.com/data/SalesOrderHeadersV2?cross-company=true
Ali1001 15 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Gunjan,

when used above format I still don't see any data. Please view below screenshot
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Hi Ali,

The URL we usually use for Odata feed is in this format -

xxxxxxxxxx.dynamics.com/data/SalesOrderHeadersV2?cross-company=true

Could you try this and check if you can see any data?
Ali1001 15 on at

Like (0)

Report

RE: Can't see all entities in Power BI from Cloud based F&O

Thanks Gunjan! You have been REALLY helpful. I have tried "https://<instancename>.cloudax.dynamics.com/data/?cross-company=true" connection accepted the syntax but still not displaying any data in the tables.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans