cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rsankar Frequent Visitor
Frequent Visitor

PBI Desktop: D365 operations - Few tables not imported with oData

I'm trying to create a report in Power BI with Dynamics 365 online (AX) data source.
My goal is to create report which shows the customer invoices which crossed the due date.

Steps I did:
1. Data Source: Dynamics 365 (online)
2. Web link: https://dynamics365XXXXXXXXXXX.cloudax.dynamics.com/Data
3. Signed in with organizational account.

What I see:
I can see the Customers, Vendor, Users details.

What I don't see:
Customer transactions
Vendor Transactions


Could you advise whether I need to activiate any security or it's a limitation?

3 REPLIES 3
v-huizhn-msft Super Contributor
Super Contributor

Re: PBI Desktop: D365 operations - Few tables not imported with oData

Hi @rsankar,

After research, you need to check if you can load all the tables in the URL? If it allow Power BI to get the data, we can see it normally.

Thanks,
Angelia

rsankar Frequent Visitor
Frequent Visitor

Re: PBI Desktop: D365 operations - Few tables not imported with oData

HI Angelia,

 

It's not pulling all tables. As per my research, it should have a data entity and it's properties "Is public" should be true. To achieve this, we need to connect to AX with remote connection and add a Data Entity for CustTrans and set it to public with the help of visual studio. 

 

While doing this I'm having few roadblocks Smiley Wink

1. Can't able to edit "Application Suite" model.

2. Tried to use "Tutorial" model, while creating data entity I'm having an issue "Natural key for the table CustTransnot found". 

 

Trying to crack this. If someone already found solution means please advise me.

 

Thanks,

Sankar

v-huizhn-msft Super Contributor
Super Contributor

Re: PBI Desktop: D365 operations - Few tables not imported with oData

Hi @rsankar,

I test and all work fine. Please check your account and authentication.

Thanks,
Angelia

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 918 guests
Please welcome our newest community members: