Azure database vs JSON files

[Alexandra_B]

Hello.

I create reports and dashboarded based on API responses that I get when I execute a Postman collection.

I have the API calls added to the collection, and I created a node file to get the result in JSON files that are refreshed a couple of times a day (manually).

I haven`t used Azure database before, but I am trying to find ways to automate the API so I was thinking if I create a database, I would be able to refresh the data automatically (I cannot do it using Microsoft Power BI). and then connect the database to PowerBI.

I am looking to do this change for automation reasons, and also I`m hoping to change the resolution of data (from hourly results to min by min).

Could you give me some advice please?

Thank you.

[Alexandra_B]

Hi @v-shex-msft ,

I have tried, but I`m failing somehow.

I was wondering if, instead of creating databases that could be populated with API results, to link Postman to Power Bi. Or I don`t know another option. Will this be posible? I have a Postman collection already and I can create a collection for each dashboard I need data for.

Thank you.

[v-shex-msft · Accepted solution]

HI @Alexandra_B,

Did you mean to use API to control/manage the dataset refresh? If that is the case, you can refer to the following link about using power automate to refresh power bi datasets:
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

Regards,

Xiaoxin Sheng