How to input data from MongoDB into ADF pipeline to refresh PBI dataset

Alan Pitthan 40 Reputation points
2023-05-31T14:52:36.6466667+00:00

Hello,

I have seen that is possible to refresh powerbi datasets using an ADF pipeline. However, I have the task to refresh said datasets using updated data from MongoDB. So, how setup this connection and make it automated? In a short manner, I would like to be able to parse the JSON
string from mongo into the request´s body on the API that connects to powerbi dataset on the ADF pipeline.
It would be much appreciated if I found a tutorial video about that.

Thank you,

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,158 questions
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,261 Reputation points
    2023-05-31T16:02:43.34+00:00

    Hello @Alan Pitthan Thanks for reaching out on this forum.
    Few more clarifications could help better understand the scenario requirements!!!

    1. Did you try connecting to the Mongo DB from ADF pipeline? and how does the data coming from MongoDB look like? any sample JSON format?

    2 What is the actual DataSource for your PowerBI? is it any Database or any other sources?

    1. And the requirement is to update the DataSource/DataSet of the PowerBi from ADF, right?

    I see that you already know about the Dataset Refresh activity from ADF!!!

    I have tried the PowerBi REST API to refresh the Dataset directly.
    If your PowerBi is using any Database , then it can be updated and the PowerBi automatically gets refreshed as the backend dataset is updated!!! Please let us know your scenario and we would be happy to help!.
    User's image

    User's image

    User's image