REDCap Data Source Not To Schedule Refresh

[nchitsulo]

I used redcap connector to connect redcap data to powerbi desktop. I installed the on-premise gateway and then published the dashboard to the power service. When I go to settings of the dataset to set up schedule refresh the below messages pop up.

Please help.

 

 

[MAwwad]

It seems that your Power BI dataset is a DirectQuery or Live Connection to REDCap and as a result, it doesn't support scheduling a refresh. DirectQuery or Live Connection data sources require real-time access to the source data, as the data is not stored in the Power BI service. You may want to consider importing the data into Power BI instead of using a DirectQuery or Live Connection to allow scheduling refresh in the Power BI Service.