Forum Discussion

ram_ssj26's avatar
ram_ssj26
Regular Visitor
5 years ago
Solved

Retrieve calculated dataset from a PBI report in Flow.

Hello, I'm new to PBI and need to retrieve calculated dataset from a PBI report in a Flow. As i see no such PBI connectors offered by MS Flow, i'm open to any alternatives. Any help is appreciated.

 

Thanks!

Sai

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI ram_ssj26,

    Currently, power bi service does not contain a writeback feature to interact with corresponding dataset and rest API.
    In my opinion, I'd like to suggest you consider GilbertQ 'a suggestion to use other tools(e,g. power bi Automate or MS flows...) to process these operations.

    You can use them to import dynamics 365 records to create a push dataset, this type of dataset allows you to do operations its data with rest API.

    Power BI automation documentation 

    Push data into a Power BI dataset 

    Regards,

    Xiaoxin Sheng

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi ram_ssj26 

     

    Currently it is not possible to get a Power BI dataset using Power Automate (FLow) the only option currently is Paginated Reports which you can use with Power BI Premium per user.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi ram_ssj26,

    So you mean you want to connect to power bi service dataset with other connection modes that allow you to do some modification with its data mode table structures? (current power bi service connector use live connection which will disable the edit feature of data models)

    If this is a case, you can take a look at the data connectors of azure blob storage(dataset)/data lake(data flow) which power bi use to host the source data or try to use web connector to analyze correspond rest API.

    Regards,
    Xiaoxin Sheng

    • ram_ssj26's avatar
      ram_ssj26
      Regular Visitor
      5 years ago

      Hi Anonymous ,

       

      Currently we are importing data from Dynamics 365 into Power BI and performing some calculations. I want to retrieve the end product from PBI (calculated dataset) and do some data updates in Dynamics 365.

       

      Thanks,

      Sai

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI ram_ssj26,

        Currently, power bi service does not contain a writeback feature to interact with corresponding dataset and rest API.
        In my opinion, I'd like to suggest you consider GilbertQ 'a suggestion to use other tools(e,g. power bi Automate or MS flows...) to process these operations.

        You can use them to import dynamics 365 records to create a push dataset, this type of dataset allows you to do operations its data with rest API.

        Power BI automation documentation 

        Push data into a Power BI dataset 

        Regards,

        Xiaoxin Sheng