Finance | Project Operations, Human Resources, ...

In microsoft Power Bi ,I can not see the all tables in getdata.

(0) Share

Report

Posted on by Zahra Mirzazadeh

156

HI ALL,

In microsoft Power Bi ,I can not see the all tables in getdata.

How can i see all tables in Microsoft power bi --GetDate--SqlServer

Best regards,

Zahra

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Hi Zahra,

Are you connecting to Entity store DB or AXDB. Entity store only has aggregated measures. If you need tables you need to either replicate tables to another DB or connect to AXDB.

Also take a look at discussion we had on similar topic.

community.dynamics.com/.../d365-f-o-on-premise-integration-with-powerbi

Was this reply helpful? Yes No
André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

Like (1)

Report

Hi Zahra,

Is this question related to Dynamics 365 Finance? Or is it a general Power BI question? If it is the last, you can also try to ask your question on the Power BI forum: https://community.powerbi.com/

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear Satish,

I used on-premise D365 FIN&OP and also used AXDB, But I can't see all of the tables, For examples for "VendInvoiceJour" table, I can not see this table but I can see just View of this table.

Thank you in advance for any help?

Kind Regards,

Zahra

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear Andre,

I mean on-premise D365 FIN&OP and I want to make Dashboard via Power BI.

Kind Regards,

Zahra

Was this reply helpful? Yes No
Juanse 660 on at

Like (0)

Report

Hello,

Have you tried to write the select SQL statement and using that method to bring in the data from the vendinvoicejournal. Sometimes that PowerBI form won't show all the tables if there are too many.

Regards,

Was this reply helpful? Yes No