Manual refresh not working on Live Connection Mode

[vickyprudhvi]

Hi,
I have connected SharePoint List to SSAS Tabular , which in turn used in the Power BI Dashboard. I am able to see the changed data in ssas tabular When I change the data in the SharePoint list and Process the SSAS tabular. But I am not able to see the updated changes in data in the dashboard. its on live connection mode. Kindly help me

[Anonymous]

@vickyprudhvi I've seen several posts over the last few days related to live connections not refreshing in a timely manner. Does the problem persist over a long period of time? Other posters say it is taking between 15 - 30 minutes to see a refresh of certain things.

[vickyprudhvi]

Hi,

Thank you for your reply.  Its taking very long time to refresh. If i have used that existing column or measure in a dashboard then it is taking long time to refresh. But if I am using the same measure or column in a new page it refreshes in 5 to 10 mins. What is the main reason behind this

[Anonymous]

@vickyprudhvi Typically you should see the data change in the report as you develop. The Dashboard tiles will always take a bit longer to refresh as I believe the stated time is every 10 minutes or so. As to "why" this refresh issue is happening, I don't know.

[vickyprudhvi]

 Is there a way I can change the stated time ?

If we close the dashboard and reopen it then updated data can be seen immediately.But i want it to happen on live

[Anonymous]

@vickyprudhvi I am not aware of any way to set a refresh time for live datasets. The only recent addition to refreshing tiles was a manual process. You can click the elipses in the far upper right corner of the dashboard and select "refresh dashboard tiles".

[vickyprudhvi]

@Anonymous I can't find hthe "elipses in the far upper right corner of the dashboard ". are you talking about Power Bi Desktop or services?.

I am using the latest version for Power BI desktop

[Bjoern]

@vickyprudhvi He is talking about the Web Service. In PBI Desktop you should have a "Refresh"-Button. it looks a bit like in excel:

[vickyprudhvi]

@Bjoern hey that in the tab section above the dashboard design area. I thought he was talking about sumthing different one. as I tried even that and it doesnt update the data immediately or after 10 to 15 mins

[Bjoern]

@vickyprudhvi Usually the refresh should work. For me, this was the case until 2-3 days ago. Since yesterday I also encountered SSAS update errors:

Please take a look here:

http://community.powerbi.com/t5/Desktop/Publishing-to-Service-in-November-Update/m-p/10787#U10787

http://community.powerbi.com/t5/Service/Changes-to-tabular-model-and-the-analysis-services-connector...

To be honest, it does not sound like a good solution, but more or less that PBI is buggy in that regards.

[vickyprudhvi]

@Bjoern Thanks for the link. the issues that are mentioned in those post are related to online. where as mine is on desktop. when there is a change in column or new measure added or changes in existing measure are reflected immediately but when there is  change in data then there is no change in the dashboard until I close the dashboard and reopen it.

[Bjoern]

@vickyprudhvi There are no dashboards in PBI Desktop.

Usually the "refresh" button also works for data (new lines) and not only data model changes (new measures, columns etc.).