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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Adlu
Frequent Visitor

Connecting to external accounting database

Hi guys!

 

I'm quite new in Power BI and I'd want to prepare a dashboard based on the accounting data (general ledgers, journal entry).

 

Our company has differrent accounting providers across many countries with diverse accounting systems. Some of the systems are modern but a there are also some old with just simple actions. What is the easiest way to automatically download data from their accounting systems? I've read some guides but it's still not clear for me.
Could you please help? Would be really greatful!

2 REPLIES 2
amitchandak
Super User
Super User

@Adlu ,

Direct from database, ODBC, ODATA feed, REST API. Depend what is available

I'm on the step of getting detailed info about all the systems. Do you think if even a really old/simple system should be able to download data in this way? Could there be a problem granting access if the accounting firm is external?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.