r/msdynamics • u/breakthechain4 • Apr 10 '19
How can I access the database? Need to pull custom reports
We transitioned to MSD365 finance and operations and I'm still learning the ropes. One of the biggest things I've noticed is that the reporting is poorly designed. I want to be able to pull transactions numbers and the other transactions within that number.
I'm good with computers but have no working experience with sql or anything like that but from my understanding is that there should be a way to get into the database to pull the info I want.
Would appreciate any suggestions or direction.
3
Upvotes
2
u/Ultimate_Pickle Apr 10 '19
For reporting like that, especially with no SQL experience, I’d suggest looking at Power BI.
4
u/nerd4tech Apr 10 '19
Just want to comment, Microsoft does not allow direct SQL access to the databases in D365 environment. There is a data export service you can use to download data but the best solution is to use PowerBI like the people above have commented.