The upcoming Dynamics 365 Business Central 2024 Wave 2 release (version 25) has a lot of new features in the reporting and data analysis areas. Expect to see interesting news in the next days, like the new embedded Power BI reports:
and some brand-new Word Layout features and add-ins for designing reports (here a preview from Kennie):
But despite the biggest news, there are also small and hidden features that helps a lot on this topic.
I think that everyone of you know that in Dynamics 365 Business Central a query object enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. Query objects can also perform calculations on data, such finding the sum or average of all values in a column of the dataset. These objects are particularly important for data analysis (very performant).
If you check the latest public preview of the AL language extension, you can see that now (version 25) you can add the ToolTip property to the dataitems of the Query object:
Why ToolTips on query dataitem elements?
They will be very useful when using the query object in the web client in Analysis Mode. In this case, with Dynamics 365 Business Central version 25 the Analysis Mode user interface will show you the table’s field ToolTip value by default (if it’s defined at the table level). If a query object adds a ToolTip property to a field (dataitem element), this new ToolTip value will override the ToolTip value defined at the table level.
This will permit you to define more user-friendly data analysis UI in the web client. Small additions but nice… 😉
Stefano Demiliani 
First they should fix this! Tooltips on tableextension are not translated · Issue #7778 · microsoft/AL (github.com)
LikeLiked by 1 person
Using Graph API, how could I generate a hyperlink to a BC Sales Order?
I am able to get data from BC using Graph API but what if I wanted to display a link to that Item in BC.
Is that possible?
LikeLike
Why Graph API for that? To have a link opening a BC entity, you can use the web client url format directly.
More info here:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-web-client-urls
LikeLiked by 1 person
I read this article prior. I still do not see how I can take the Information that Graph API gave me to generate the link/url. I have Graph API working in Power Apps and we need a link back to BC from the Power App.
LikeLike
Here’s what I was able to come up with.
page=id
was the key, we can direct users to a page with a table and pre filter the table.
Like this
“https://businesscentral.dynamics.com/<aadtenantid>/Production/?company=<companyname>&page=9305&filter=’No.’+IS+'” + varSalesOrderNumber + “‘&dc=0”
Thank you for your pointer.
LikeLike