Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Automate visual refresh after data model update in import mode

Hi, I have some reports to be displayed on screen in the office, relying on import dataset with hourly update. Is there a way to automatically update visuals after the dataset has been updated, or ...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

You could consider using the direct query mode, or to refresh the dataset manually.
The method you chose, while not seemingly elegant, it is indeed a viable workaround.

 

Import connection is recommended when the data size is less than 1 GB and the data is not continually changing. You can import data with schedule refresh to get the latest data.

Direct Query sends the query to the data source at the time of render, so data is always as current as your data source.

 

more information about Import vs DQ:

direct query vs. import

DirectQuery, Live Connection or Import Data? Tough Decision!

 

 

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.