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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Power Bi and live streaming data for on premise CRM

(0) ShareShare
ReportReport
Posted on by 6

Hello All Experts,

Is it possible to utilize live streaming dataset for on premise CRM.

it will be really helpfull if anything that can be given as a reference.

i have tried with Microsoft flow , Power bi live streaming dataset and then CRm online .

But i need to do it for CRM on premise database.

I have the same question (0)
  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at

    Hi,

    Thank you for your query.

    I believe, for online, you use Flow (triggered on Create/Update of a record) to push data to Power BI Dataset. However this is not possible with On-premise. Because, Microsoft Flow do not have a connector for D365 On-premise.

    As an alternate, I would suggest:

    • Create a Streaming Dataset in Power BI (as you did for online).
    • Then, create a custom code activity (workflow) or plugin to push insertions/updates to Power BI dataset.

    You can push records to Power BI Data set using Power BI APIs:

    http://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-add-rows

    http://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-add-rows

    To summarize, instead of using flow to push data to PBI Dataset, you have to write your own code which triggers within CRM to push data to PBI.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 51

#2
Martin Dráb Profile Picture

Martin Dráb 39 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans