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:

Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

RE: New field & Power Bi Dataset

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
Suggested answer

MahGah 15,428 on at

Like (0)

Report

RE: New field & Power Bi Dataset

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