Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

direct query and data refresh

Hello together,   I have a problem with the direct query. Power BI Service shows that everything works fine and is connected. The problem is that the data don´t change, even if I klick on "Refresh ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

Does this dataset get data both from SQL server and two excel files? After refresh successfully, how about the result when you refresh the report page?

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-qiuyu-msft,

 

yes the dataset get the data of both. Above the refresh history Power BI says that my gateway and the data sources are online. When I want to refresh the report after successful refreshing of the dataset, I can see that it actualizes because of the rolling balls on the visuals, but nothing happens after that.

 

Best regards

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Anonymous,

     

    Please double confirm when you refresh the report in desktop at the same time you refresh the dataset in service to see if you get the same results.

     

    In service, after dataset refresh successfully, please edit report online, then add a visual to see if the updated data displays.

     

    Best Regards,
    Qiuyun Yu