Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SimmoMac
Frequent Visitor

Convert A Microsoft Dynamics NAV report directly to Power BI

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

1 ACCEPTED SOLUTION

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





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




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





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

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?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors