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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Server and DB names in...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Server and DB names in PROD and UAT env for BI reports

(0) ShareShare
ReportReport
Posted on by Community Member

Team,

I have developed a customized BI report in DEV box using SQL Server and connecting to AXDW with direct query approach.

In dev box -

(Given server name as . and DB name as AXDW while connecting to SQL server in BI file.)

Further, I add the BI file to Asset library and click on deploy all BI files in UAT and PROD environment.

How will the server and DB connections change accordingly in UAT and PROD environments?

Do we have to make any settings? 

Quick help will be appreciated!

Thanks!

I have the same question (0)
  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    "Directly connecting to the production database is not possible."

    community.dynamics.com/.../connecting-power-bi-to-prod-environment

    community.dynamics.com/.../power-bi-on-d365-for-finance-operations-direct-query

  • Community Member Profile Picture
    Community Member on at

    I agree. 

    Thus I create a BI report in DEV using entity store and connecting via AXDW. 

    When we migrate it to UAT and PROD, we first store the BI file in Asset Library. 

    Further when we deploy BI files through D365 environment from system administration -> powerbi.com configuration, will it automatically take the UAT / PROD data and show the results?

  • ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    There are many ways to use BI in Prod, but they all basically use entities (or aggregate measures etc.). If you wrote your report using sql tables, you cannot use it in prod. (At least there is no method that I know of, of course you can get a copy of the prod, but there is no structure that can be used for reporting purposes)

    In fact, if you look carefully at the links I share, they will guide you on how to use them.

    Edit: I didn't see the data entity part in your replay

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    Sorry, I was reading from the phone and I just realized that you are using a data entity.

    System Administration > Setup -> Deploy Power BI

    community.dynamics.com/.../deployment-of-power-bi-reports-to-sandbox-and-production

    docs.microsoft.com/.../power-bi-content-from-microsoft-and-your-partners

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans