Creating Report in Power BI Service Environment With Direct Query

[prakash_satya59]

Hi Team

I am trying to create a report in power bi service environment. 

Step I am following

1- Created a dataflow>Used SQL Source. Put my query for creating dataflow. Saved. On the setting for Enhance compute Engine Setting.

2- Created one datamart>  Taken above dataset as source for this datamart. Seen In model view. Its shwoing Directquery in advance option. 

3- With This datamart , created one report in power bi service. 

For the page refresh option, I selected "Change Detection " option, but there is one error I am getting as "Your change detection measure was not set up properly, so the page would not automatically refresh. to fix this contact your report owner"

I have seen in my sql database, result is changed but when I opened my power bi report, report is still unchanged. 

May you please help my . How I can do the setting to do auto refresh where there will be any changes in my database/view,/ tables.

[lbendlin]

A dataflow is by definition import mode.  You need to have a schedule set up to refresh it (and push the changes to the datamart).

Can you set up a Direct Query connection to your SQL Source? What type of SQL, On-Premise or Azure?