Forum Discussion

prakash_satya59's avatar
prakash_satya59
Frequent Visitor
2 years ago

Creating Report in Power BI Service Environment With Direct Query

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.

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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?