Convert A Microsoft Dynamics NAV report directly to Power BI

[Anonymous]

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

[StefanoGrimaldi]

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 

[StefanoGrimaldi · Accepted solution]

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial 

[StefanoGrimaldi]

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 

[Anonymous]

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?