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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Modify existing out of...
Finance | Project Operations, Human Resources, ...
Answered

Modify existing out of box Credit and collection power BI report in D365 F&O

(1) ShareShare
ReportReport
Posted on by Rhushikesh R 758
Hi Everyone,
 
I want to modify existing Collection status power BI report present in Credit and collections workspace.

I downloaded power BI desktop, connected to local host and opened Credit and collections management report from below path
 
K://AosService//PackagesLocalDirectory//ApplicationWorkspaces//ApplicationWorkspaces//AxResource//ResourceContent//PowerBIReport

I found that entity being used here is CustCollectionsBICollectionStatus, so I will be adding my custom field into this entity. And then will add same column on BI report as well.
My question here is, how should I deploy this report to any environment. When it's DEV, I can copy the pbix file directly into K://AosService//PackagesLocalDirectory//ApplicationWorkspaces//ApplicationWorkspaces//AxResource//ResourceContent//PowerBIReport
 
But what if I want to deploy it to any other environment?

Also, as this is standard report, when we try to deploy report with same name, will it overwrite existing one? And will reflect my change into it?

 
 

 
 
I have the same question (0)
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Modify existing out of box Credit and collection power BI report in D365 F&O
    Hi,

    To modify the existing Collection Status Power BI report in the Credit and Collections workspace, you can follow these steps:

    1. Open the desired report file (.pbix) using Power BI Desktop.
    2. In Power BI Desktop, you can make modifications to the data model and visualizations, including adding custom fields.
    3. Once you have completed the modifications to the report, save it and publish it to the target environment.

    As for deploying it to another environment, you would need to use the appropriate deployment method based on the specific requirements of the target environment. One common approach is to use the data export/import functionality in Dynamics 365 F&O to export the modified report from one environment and import it into another environment.
    Since this is a standard report, if you attempt to deploy the report with the same name, it may overwrite the existing one. When deploying, make sure to use a new report name that does not conflict with the existing report to avoid accidental overwriting and data loss.

    Best regards,
    Kevin
  • Rhushikesh R Profile Picture
    Rhushikesh R 758 on at
    Modify existing out of box Credit and collection power BI report in D365 F&O
    Hi Kevin,
     
    thank you for the detailed response.
     
    I will verify your answer shortly.
     
    Just have 2 follow up questions on your response,
     
    1. Do you have any link handy for Import/Export approach? If yes can you please share it here?
     
    2. And when I will deploy the report with new name, will I be able to show the report in the same section of workspace? If not, can I hide the existing standard one and display just new modified one?
  • Verified answer
    salman ahmad Profile Picture
    salman ahmad 176 on at
    Modify existing out of box Credit and collection power BI report in D365 F&O
    Hi the reports that are out of the box in d365 are based on the AXDW.
     
    please open these reports in devlopment envirement and make sure to update or refresh the entity store.
     
    Change anything in the report save it.to deploy on any other envirement 
    sign into lcs.
    go the asset library.open the power bi models
    add the new one and release canidate.
    now go to F&O and deploy the report from sys admin.
     
    create a new workspace jump to options and add report there hope it will work :))))
  • Rhushikesh R Profile Picture
    Rhushikesh R 758 on at
    Modify existing out of box Credit and collection power BI report in D365 F&O
    Tank you Salman and Kevin for the detailed responses. Due to some technical glitch in the site, I am unable to verify Kevin's answer.
    Both responses are helpful to me.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans