I am using Dhis2 connector in power bi desktop. It works very well in my power bi desktop. Then I published the report to power bi service so the report can be seen by other team members. whenever I want to get update from DHIS2, I have to refresh in power bi desktop then published to the service. When I tried to make automatic schedule refresh, it doesn’t work.
Can anyone guide me how to do it.
1 Like
Hi @Kyawmoewai_Ngp
Welcome back to the community! It’s great to hear that the connection is working as expected (did you use this app: Power BI Connector ?)
So the refresh needs to happen in Power BI itself? This seems that it is a configuration in Power BI side? How did you configure the scheduled refresh?
Thanks!
Yes I am using this connector. By usimg this connector, I pull the data from dhis2 aggregate data entry forms. Then created a power bi dashboard and uploaded this dashboard to Power Bi online service. In power bi online service there is a function to set a schedule refresh. it doesn’t work.
Onther other hand, I used api to pull DHIS2 tracker data to power bi desktop by using api. And created the process with above one. the power bi dashboard that get the data from api can set the automatic scheduled refresh on the power bi online service.
how should I write api to get data values from the aggregate datasets so that I can pull data by using api and can make a schedule refresh.