Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI reports data connect with REST API and reload data on Refresh dashboard.

Hi All,

 

I am new to Power BI, Sorry for my stupid question but I am trying to build the dashboard which takes data from REST API and everytime I refresh/reload the Dashboard of Power BI it should fetch the data from REST API to show. 

 

is it possible? if yes, Please help. I tried multiple things but after publishing report it is not taking data from REST API. I mean its content is not changing even the API response data is changed.

 

 

Please let me know how I should proceed to do acheive this.

Dataflow
Need Help
Tutorial Requests

11 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi, that is not exactly possible. You have two scenarios that can help.

    1- You schedule refresh the rest api get data methods for your dashboard. (Up to 8 times a day in pro/free licence)

    2- You can create a Streaming data set. In this case you can develop an app to POST the data to Power Bi service. For example trigger your data changes to move them to power bi at the exact moment. This way power bi will give you an URL to post the data with a body json as an example.

     

    Regards, hope this helps

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • GilbertQ's avatar
      GilbertQ
      Super User
      6 years ago
      Hi there

      Firstly I always say that there are no stupid questions!

      As mentioned above, what you would need to do, is to create the call to the REST API using Power BI Desktop.

      You would then need to configure the scheduled refresh if all your data is only coming from a web based REST API. This will allow your data to be refreshed on the schedule.

      Once the above is done, you can then create a dashboard by pinning visuals from your Power BI Report to a dashboard.

      The dashboard tiles will automatically update when the underlying data is refreshed.
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks GilbertQ  I will use schedule refresh but I have Graphql API which takes the request params like

               My POST API looks something like https://**************.com/api/v1/get_data

        {
          packMarketPent(periods: {start_date: "2019-01-01", end_date: "2019-10-01"}){
            channel
            service_name
            metric_absolute_actual
          }
        }

         

        Can you pls help me whats the best possible way to use this API in POWER BI 

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,


    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.


    Best Regards
    Icey