Forum Discussion
Reports based on Dynamics
When using PowerBi to create a report based on its link to Dynamics, the report is missing large amount of entries. For example, 15 on PowrBi, versus the same inquiry on Dynamics gets 81 entries.
Hello JWharton
You may need to create a Power BI report using OData feed connection. OData connection will take the Data entities of Dynamics 365 as data source to create reports.
Please refer to these related threads for more details.
Power BI with Microsoft Dynamics 365 for Finance and Operations
How to Connect Power BI to D365 Finance and Operations
YouTube_Power BI Odata connection to Dynamics 365 Finance and Operations data entities
If the above does not solve your problem, then we need to look at the Power Query Level to check if no filters have been applied on any of the tables, as if some data is getting loaded in the PBI, which means you might be connecting correctly.
7 Replies
JWharton How are you connecting?
Hello JWharton
You may need to create a Power BI report using OData feed connection. OData connection will take the Data entities of Dynamics 365 as data source to create reports.
Please refer to these related threads for more details.
Power BI with Microsoft Dynamics 365 for Finance and Operations
How to Connect Power BI to D365 Finance and Operations
YouTube_Power BI Odata connection to Dynamics 365 Finance and Operations data entities
If the above does not solve your problem, then we need to look at the Power Query Level to check if no filters have been applied on any of the tables, as if some data is getting loaded in the PBI, which means you might be connecting correctly.
Your Power BI report linked to Dynamics is showing fewer entries because of one or more of these reasons:
- Hidden filters in visuals or queries
- Import mode pulling outdated data
- User permissions limiting record visibility
- OData row limits (e.g., 5000 max)
- Missing joins or relationships between tables
- Data type mismatches causing silent drops
✅ Check filters, refresh the dataset, and consider using the Dataverse TDS endpoint for full access.Hi JWharton,
Thanks for reaching out to the Microsoft fabric community forum. The difference you’re seeing between Dynamics (81 records) and Power BI (15 records) usually happens due to how the data is being brought into Power BI. As
Shahid12523 and NimaiAhluwalia has already responded to your query with trouble shooting steps, so kindly go through the steps and check if your issue can be resolved.
I would also take a moment to thank @, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.Hi JWharton,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround so that other users can benefit as well. And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi JWharton,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.Best Regards,
Hammad.
