How to change the data rendering from import to dynamic

Question

Hi ,I have a report pointing to a view. The problem is it is not refreshing unless i&nbsp; manually refresh and publish it. Instead of pointing to the view i want to select (select * from view) and make it dynamic. How can i change that?Thanks

stevecampbell · Answer

Think you are wanting to check out this:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Some additional tips here:

https://powerbi.tips/2019/09/power-bi-refresh-overview/

Appreciate your Kudos
Connect with me!

Stay up to date on
Read my blogs on

anonymous · Answer

Will test this option&nbsp; and update here.&nbsp;Thanks

anonymous · Answer

Still testig as there are few steps involved. The ETL Team refreshes a view ( i am checking if their job is refreshing as supposed to). On the Power BI side the data is stale, so wanted to make sure if it is the ETL load process or the BI side. Once i get confirmation will update here.

Thanks

anonymous · Answer

Thanks SteveCampbell i am looking for hourly refresh and this link wont let me do that , it will let me do the refresh only once. The VIEW (SQL Server) gets updated every hour and my mistake ( really not sure why we cannot change the way the data is rendered once the report is created) i just selected the VIEW instead of using Direct Query (select * from view)

Bottom line is that the report needs to be refreshed every hour.

Thanks