Forum Discussion

michael_mcclari's avatar
michael_mcclari
Regular Visitor
6 years ago

Get Value of Measure from Power BI Service from REST API or another method

Hello, I have created a report in Power Bi Service that has measures that calculate data to determine a business direction based on the data. I would like to connect to these measures to use their current value in internal tools that will allow automatic changes within these internal tools based on the data within the measures. So ideally I would make an REST API call to the Power BI Service and use the data in my internal tools. But upon looking at the Power BI Service REST API documentation, this does not appear to be possible. https://docs.microsoft.com/en-us/rest/api/power-bi/

Do you happen to know a way to work around this limitation and get the values of the measures from the power bi service in real time and without manual work?

2 Replies

  • Hi michael_mcclari 

     

    You cannot query measures/data from the underlying data model in Power BI. If you have Premium capacity, then you may be able to query it.

     

    As a workaround you can set alerts on your measure and setup a Power Automate to push values to database. Or you can use AAS to build the model (big investment?)

     

    -Ranbeer

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ranbeermakin 

    Can you provide any articles about "set alerts on your measure and set up a Power Automate to push values to database", please?
    Thank you in advance.