Share
ReportHi,
Is it somehow possible to make a custom Excel export in the Excel workbook designer?
You’re offline. This is a read only version of the page.
5
Hi,
Is it somehow possible to make a custom Excel export in the Excel workbook designer?
Hi Dax24,
If you see a solution workable for you then can you please mark this a Suggested Answer so that It can help others.
Hi Dax24,
Thank you for your explanation. You cannot do it in the Excel workbook however there is a workaround.
You can use Excel and Click on Get data and select Odata.
Provide your environment OData URL and select the entities which you want to merge
In this way, you can combine information from multiple entities using Power query
Note: Odata can be slower when you have more data and joins.
Check the reference URL for using Power query with merge functions.
Hi Parag,
It is worker information such as name, start date, end date, Company e-mail, intials (custom field), employee number and position information such as finacial dimensions, reporting to (name of the manager) etc.
I can find some of the i formation in the exsisting workbooks in D365 HR but would like to avoid downloading 3 different workbooks and merge them afterwards is it at all possible to make a new workbook where i can select from all the data entities?
Hi Dax24,
Do you have any example of what you would like to export with custom excel?
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
