Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have Report that I take out of Microsoft Dynamics Navision called 'Aged Account Receivables' that i need to duplicate in Power BI.
to do this manually is a long gruelling process, so i'm just thinking (i know its a long shot) but if anyone has a way of converting it. this is the Nav development notes: (if they help/ make any sense)
Expanded | Data Type | Data Source | Name | Include Caption |
1 | DataItem | Customer | Customer | No |
0 | Column | FORMAT(TODAY,0,4) | TodayFormatted | No |
0 | Column | COMPANYNAME | CompanyName | No |
0 | Column | STRSUBSTNO(Text006,FORMAT(EndingDate,0,4)) | FormatEndingDate | No |
0 | Column | STRSUBSTNO(Text007,SELECTSTR(AgingBy + 1,Text009)) | PostingDate | No |
0 | Column | PrintAmountInLCY | PrintAmountInLCY | No |
0 | Column | TABLECAPTION + ': ' + CustFilter | TableCaptnCustFilter | No |
0 | Column | DPA_GetFiltersFltrGrp(0) | DPA_GetFiltersFltrGrp0 | No |
0 | Column | DPA_GetFiltersFltrGrp(7) | DPA_GetFiltersFltrGrp7 | No |
0 | Column | CustFilter | CustFilter | No |
0 | Column | AgingBy = AgingBy::"Due Date" | AgingByDueDate | No |
0 | Column | STRSUBSTNO(Text004,SELECTSTR(AgingBy + 1,Text009)) | AgedbyDocumnetDate | No |
0 | Column | HeaderText[5] | HeaderText5 | No |
0 | Column | HeaderText[4] | HeaderText4 | No |
0 | Column | HeaderText[3] | HeaderText3 | No |
0 | Column | HeaderText[2] | HeaderText2 | No |
0 | Column | HeaderText[1] | HeaderText1 | No |
0 | Column | PrintDetails | PrintDetails | No |
0 | Column | GrandTotalCustLedgEntry[5]."Remaining Amt. (LCY)" | GrandTotalCLE5RemAmt | No |
0 | Column | GrandTotalCustLedgEntry[4]."Remaining Amt. (LCY)" | GrandTotalCLE4RemAmt | No |
0 | Column | GrandTotalCustLedgEntry[3]."Remaining Amt. (LCY)" | GrandTotalCLE3RemAmt | No |
0 | Column | GrandTotalCustLedgEntry[2]."Remaining Amt. (LCY)" | GrandTotalCLE2RemAmt | No |
0 | Column | GrandTotalCustLedgEntry[1]."Remaining Amt. (LCY)" | GrandTotalCLE1RemAmt | No |
0 | Column | GrandTotalCustLedgEntry[1]."Amount (LCY)" | GrandTotalCLEAmtLCY | No |
0 | Column | Pct(GrandTotalCustLedgEntry[1]."Remaining Amt. (LCY)",GrandTotalCustLedgEntry[1]."Amount (LCY)") | GrandTotalCLE1CustRemAmtLCY | No |
0 | Column | Pct(GrandTotalCustLedgEntry[2]."Remaining Amt. (LCY)",GrandTotalCustLedgEntry[1]."Amount (LCY)") | GrandTotalCLE2CustRemAmtLCY | No |
0 | Column | Pct(GrandTotalCustLedgEntry[3]."Remaining Amt. (LCY)",GrandTotalCustLedgEntry[1]."Amount (LCY)") | GrandTotalCLE3CustRemAmtLCY | No |
0 | Column | Pct(GrandTotalCustLedgEntry[4]."Remaining Amt. (LCY)",GrandTotalCustLedgEntry[1]."Amount (LCY)") | GrandTotalCLE4CustRemAmtLCY | No |
0 | Column | Pct(GrandTotalCustLedgEntry[5]."Remaining Amt. (LCY)",GrandTotalCustLedgEntry[1]."Amount (LCY)") | GrandTotalCLE5CustRemAmtLCY | No |
0 | Column | AgedAccReceivableCptnLbl | AgedAccReceivableCptn | No |
0 | Column | CurrReportPageNoCptnLbl | CurrReportPageNoCptn | No |
0 | Column | AllAmtinLCYCptnLbl | AllAmtinLCYCptn | No |
0 | Column | AgedOverdueAmtCptnLbl | AgedOverdueAmtCptn | No |
0 | Column | CLEEndDateAmtLCYCptnLbl | CLEEndDateAmtLCYCptn | No |
0 | Column | CLEEndDateDueDateCptnLbl | CLEEndDateDueDateCptn | No |
0 | Column | CLEEndDateDocNoCptnLbl | CLEEndDateDocNoCptn | No |
0 | Column | CLEEndDatePstngDateCptnLbl | CLEEndDatePstngDateCptn | No |
0 | Column | CLEEndDateDocTypeCptnLbl | CLEEndDateDocTypeCptn | No |
0 | Column | OriginalAmtCptnLbl | OriginalAmtCptn | No |
0 | Column | TotalLCYCptnLbl | TotalLCYCptn | No |
0 | Column | NewPagePercustomer | NewPagePercustomer | No |
0 | Column | PageGroupNo | PageGroupNo | No |
2 | DataItem | Cust. Ledger Entry | <Cust. Ledger Entry> | No |
2 | DataItem | Cust. Ledger Entry | OpenCustLedgEntry | No |
2 | DataItem | Integer | CurrencyLoop | No |
1 | DataItem | Integer | CurrencyTotals | No |
0 | Column | Number = 1 | CurrNo | No |
0 | Column | TempCurrency2.Code | TempCurrCode | No |
0 | Column | AgedCustLedgEntry[6]."Remaining Amount" | AgedCLE6RemAmt | No |
0 | Column | AgedCustLedgEntry[1]."Remaining Amount" | AgedCLE1RemAmt | No |
0 | Column | AgedCustLedgEntry[2]."Remaining Amount" | AgedCLE2RemAmt | No |
0 | Column | AgedCustLedgEntry[3]."Remaining Amount" | AgedCLE3RemAmt | No |
0 | Column | AgedCustLedgEntry[4]."Remaining Amount" | AgedCLE4RemAmt | No |
0 | Column | AgedCustLedgEntry[5]."Remaining Amount" | AgedCLE5RemAmt | No |
0 | Column | CurrSpecificationCptnLbl | CurrSpecificationCptn | No |
Solved! Go to Solution.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Proud to be a Super User!
on power bi desktop look for the sql server source conector, them get that server IP, and the nav sql database name and with that you can explore it
Proud to be a Super User!
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Proud to be a Super User!
if this its the server installed version yes, connect to the sql source of the server where its installed the navision, it should be somewhere saved either a view or a function that generates this report that you can connect directly to have the same report with the same logic and all
Proud to be a Super User!
Hello,
I kind of understand what you're saying but how do i connect Power BI directly to the SQL? or do you mean copy the SQL code?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.