Scheduled or auto-refresh for desktop version

[ecroke]

I have created a dashboard in Power BI Desktop and published it. If I share this Dashboard with my colleagues is there any way for the Data in the Dashboard to be automatically refreshed so they can see the most recent version? The Data I am using for the dashboard comes from a SQL Server and I Imported the data.

[Anonymous]

Hi

I hope you know that we have two options available in SQL Server i.e Import and Direct Query. 

If you choose Import then it will import all your data to Power BI Service (cloud) and show the report and dashboard from your data. In this case, data is very close to reporting and it will not look for data changes.

In case, if you choose Direct Query, then data will remain in your on-premises and only the data required for a report will send to Power BI via personal or enterprise gateway. In this scenario, we have an option to set up a dataset refresh (schedule).

Make sure you are using Direct Query mode and look for schedule refresh in dataset section under settings.

Thanks

Hari 

[ecroke]

@Anonymous When creating it I used Import as got the data from a SQL server and I needed to add extra fields to the data. Is there any way of changing it to a direct query?

[Anonymous]

There is a chance to change from DirectQuery to Import but you can't change from Import to Direct Query. You need to build the model in Direct Query from scratch.

Ref: http://community.powerbi.com/t5/Desktop/How-can-I-switch-the-connection-setting-from-Import-to/td-p/...

Thanks

Hari

[MFelix · Accepted solution]

Hi @ecroke,

You have to set up a gateway in order to have your information update automatically, please refer to

https://powerbi.microsoft.com/en-us/gateway/

Regards,

MFelix

[aishwaryaz]

I am schedule dataset but my reports are not refreshing automatically in power bi. I am using MYSQL database. & i publish the report on web. I want to refresh my powerbi reports & web published reports automatically. Plz help me