Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Get FO on-cloud AXDW d...
Finance forum
Unanswered

Get FO on-cloud AXDW data in Power BI

Posted on by 134

Hi Community,

I have an on-cloud dynamics FO VM having FO environment and SQL server installed there. I get the AXDW data of FO by refreshing the entity store cube in FO and then data is generated in SQL Server AXDW database. Then I get the data in Power BI by connecting the BI with SQL server by providing the SQL instance name as dot(.) and database name as AXDW.

When I want this AXDW database outside of VM what will be the SQL server instance name for that to get the data on other machine.

In short I want the on-cloud FO AXDW data on other machine for Power BI Reporting. How can I access that?

Thank you

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: Get FO on-cloud AXDW data in Power BI

    Hi Ammad,

    You can read the documentation how to get data synchronized to another Azure SQL DB which then can be accessed by Power BI. Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Docs

    Besides moving data to BYOD, you can also consider the option to export the data to Azure Data Lake. 

    These are supported options for cloud production environments. You can't access the production database directly from Power BI.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans