
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.
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:
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.