Small and medium business | Business Central, N...

New field & Power Bi Dataset

(0) Share

Report

Posted on by paolo_lito

Hello,

First I apologize if the question was already asked .

I'm a power bi developer with not a lot of knowledge in Business central ,

when I import the dataset from BC , the custom fields are not in there, I don't understand why and I need to have it because some of theme are used as primary Key .

Can you please how I can proceed ?

thanks a lot for your help

paolo

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

This is because those fields were not published in Web Services in BC. Someone in BC need to add them to ODATA. Either publish the page or add a fields to already published ODATA. I sort of put the document below on how add the fields to already published ODATA.

Please note custom fields only can add to ODATA if they are accessible or visible in Page (through personalization for example).

Go to Web Services page in BC. Then Actions -> New Document -> Create Data Set. Then Edit An Existing Dataset. Note: sometimes they need to create new dataset or copy end edit existing dataset.

Then select the page that you have custom fields in it then in the next page check and see if those fields are included or not. if not include and publish. Now you should see them in Power BI

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, The data that can be access in Power Bi is the data published in WebService and standard Api page.

So, If you add new fields, you need to modify these pages, or add new pages, as MahGah said.

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/publish-web-service

Hope this will also help.

Thanks.

ZHU

Was this reply helpful? Yes No