I have a need to access a ready-only copy of the AX business database that is sync'd in real time. We can then sync this database to our own azure sql database for reporting purposes.
Comments
Not having a real time read only copy of the database is one of our big concerns with going live.
Category: Reporting and Analytics
Surprising that two years later, there is still no solution for this must-have capability. Putting Entity Store into a Data Lake has only a very limited number of use cases.
Reporting comes at the end of an implementation project. Only then, you discover that D365FO lacks the capabilities to supply adequate solutions for your business. By then you have invested so much in the implementation that there is no way back.
Also makes you wonder why there is still no solution…
Category: Reporting and Analytics
I and Customers really want to access Read only D365 FO database to make own report as own way, because:
When I want to use Power BI to get data from D365 FO, and I very surprise that we have two way:
- Use Data entity and Odata
- Use Entity Store
Customers always to drill down to see behind the Total amount, If we use Data entity can adapt requirement, but it could not be best practice for large transaction, very slow.
And then, dedicated BI Team with traditional way to query to secondary readonly AX database, and they will not have SQL query task to do like before, and put query developed effort to AX developer team to make data entity or measurement as data source for BI Team, and BI Team have only work to do Data Visual.
Category: Reporting and Analytics
This is an ABSOLUTE MUST HAVE feature. The larger, more active tables do not support incremental loads and, as table sizes grow, full loads become impractical. Creating custom entities adds unnecessary development overhead and inhibits our ability to respond to requests in a reasonable time frame.
Category: Reporting and Analytics
Must have feature when customer have no access to its data and that these are must have data in the Customer's data warehouse
Category: Reporting and Analytics
This is a low hanging fruit that will make a lot of people happy including me!
Category: Reporting and Analytics
When I tell our accountants that Power BI can only give me aggregations of data and can't give me the numbers behind the totals they see, I get looks of total disbelief. So another vote to bring D365 reporting into the current century :-)
Category: Reporting and Analytics
Utterly critical and very much required. As an SME we don't have the time or budget to customise all of the data entities we need, making our current reporting very limited. Having access to the entire database would be massively beneficial
Category: Reporting and Analytics
Must have feature especially when our customers want to use ERP data alongwith other datasources..
Category: Reporting and Analytics
Could not agree more, our company needs this functionality for a smooth business operations.
Category: Reporting and Analytics
Administrator on 7/30/2019 3:41:40 PM
We are looking into adding more data into Azure Data Lake including the option to add Entities and key tables.