Announcements
No record found.
Hi All,
I need to execute a store procedure and get data to pass it into power BI Report. The challenge is that data has to be from d365 f&o cloud production Environment . Cannot create view or data entity because of several conditions in store procedure. Please suggest me any ideas to achieve this.
HI Anoop,
Are you exporting data to data lake for creating reports? Have you looked at this option?
learn.microsoft.com/.../azure-data-lake-ga-version-overview
No. I am not exporting data to data lake. Without exporting is there any way to connect the cloud production db
No, you can't connect directly to a production database.
You either go through the application layer (e.g. a data entity), or you export data to a separate database where you define your stored procedure.
By the way, you chose a technical solution (a stored procedure) too early, before knowing whether it's a best solution or - as you see - whether it's possible at all. Therefore limiting yourself to this particular solution would be a bad idea.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 426 Most Valuable Professional
CU10121822-0 358
André Arnaud de Cal... 353 Super User 2026 Season 2
