Automatically refresh datasets

[lcasanovar28]

Hello, 

I have defined some datasets in Hopex Studio and connected the API to PowerBI so I can generate external reports. I don't see my changes reflected in the dashboard unless I manually refresh the data set. Is there a way to manually do it?

Thanks, Liseth 

[ThomasSTA]

Hi @lcasanovar28,

I have had a similar case and can share what I figured out in regards to automatic dataset updates through the API.

I found that if you utilize the API through PowerBI or on the datasets directly that the Report DataSet does update automatically it just takes time (somwhere inbetween ~24 hours).

Steps:
- I created a Report DataSet that selected all applications "Select [Application]" as its populating query.
- Opened a PowerBI report and setup the API connection to the Dataset.
- Created a new application in Hopex.
- Refreshed the data in PowerBI the next day, and the new application was included.

Kind regards,
Thomas

[LMeden]

Hi @lcasanovar28, on the report dataset definition, try and untick "Keep last generated result".