Get table method in power BI D365

(0) Share

Report

Posted on by vicky1234

Hi,

I am having a custom table lets say "TableABC" with a method getTotal() which is sum of some calculations.

Table: ABC

Field: Hours

Method: getTotal()

I wanted to use this method getTotal value in power BI report . Can someone help me if there is way to get this method value in power BI report ?

Also does power BI report allows using a view ?

User is actually using Datalake to expose the table , however I can even suggest directly using another approach in case there is any other solution ?

Thanks,

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 303,314 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi VK,

There are several approaches. You can export tables and connect them in Synapse or Power BI to mimic the behavior of the method in Dynamics 365. You can also create a data entity with a virtual field which the can get the value from the method. Note that using a data entity with a virtual field filled by x++ coding will cause the calculation to be done per row which is negatively impacting the performance. If you can convert the method to T-SQL , this will be a lot faster.

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi vicky,

If getTotalHours is simple aggregate method for summing total hours, I think you can do that in power Bi report itself by selecting aggregate types.

Thanks,

Girish S.

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

hi Girish,

Actually I have just given an example for totalhours , my display method gives the value of workflow status approver.

Thanks,

VK

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Vicky, I think you can access table methods and map it to the data entity field. You have to create virtual field and map it in mapDataSourceToEntity method. If you get the value in data entity, it can be used directly in Power BI. However, as Andre mentioned virtual fields cause performance degradation in data export.

Check mapDataSourceToEntity in below article.

nareshdax.blogspot.com/.../entity-methods-in-ax7.html

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

hi Andre,

You mean that I should create an entity with a virtual field and that will have logic to fetch the custom method value .

Wrt conversion of method to t-sql I dont know how you can convert that part , can you please share some more inputs. I know that we create some methods with logic similar to sql syntax in views but not sure about the entities, can you please share an example.

Also can we use a view in power BI as well as tables together, or there can be only single connection at a time in Power BI.

I think we can use the entity as well.

Thanks,

VK

Was this reply helpful? Yes No
André Arnaud de Cal... 303,314 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi VK,

The virtual fields on a data entity is similar to a method on views. You can find an example on Microsoft Learn: Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No