Skip to main content

Notifications

Announcements

No record found.

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.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,994 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.

  • Anoop B Profile Picture
    Anoop B 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

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,673 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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans