Nominal Ledger Activity Data import into Microsoft Power BI

SUGGESTED

Hi,

I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There is an invoice table but it has only 16 irrelevant records. Sage 50 accounts database doesn't have nominal activity at invoice level or Is there another connector I have to use? I would highly appreciate your support.

Thanks!