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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to connect cloud production data to Power BI Report

(0) ShareShare
ReportReport
Posted on by 30

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.

I have the same question (0)
  • Sukrut Parab Profile Picture
    71,699 Moderator on at
    RE: How to connect cloud production data to Power BI Report

    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

  • Anoop B Profile Picture
    30 on at
    RE: How to connect cloud production data to Power BI Report

    No. I am not exporting data to data lake. Without exporting is there any way to connect the cloud production db

  • Verified answer
    Martin Dráb Profile Picture
    236,951 Most Valuable Professional on at
    RE: How to connect cloud production data to Power BI Report

    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.

Helpful resources

Quick Links

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

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

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 569

#3
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans