web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

creating a PowerBI dataset from bank account statement

(0) ShareShare
ReportReport
Posted on by
need to create a automatic report from PowerBI , the data I need is the bank account statement with only outstanding transactions.
 
The sequence would be from Home page >- Cash management >- Bank Accounts >- "select a bank" >- Bank account card >- Bank account >- Statements , up until this point , you are seeing bank account statement list , select the latest one and click "print" , make sure the "print outstanding transactions" option is toggled , and subsequently save to excel or other format . 
 
 
My question is , if I want to automate this process and have the result ready to be processed by PowerBI whenever I need to see this outstanding transactions , how to achieve this purpose ? is there any way by creating a web service or other methods ?
 
and if there is a customer service number I can call to have a technical support for this issue ? 
 
Thanks
BC_question_pictures.png
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 202 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans