Datarefresh between Power Bi desktop file and service

[Anonymous]

Hi team,

I have done a small POC pn Power Bi desktop. Let me give a quick background on what i did.

Using Power Bi desktop, i have connected to sharepoint online list and imported data from two lists. Then using Merge query, i did a internal join and stored the consolidated data into new dataset and published it to Power Bi online service.And i scheduled a data refresh on daily basis.

Here, my set of queries come.

When we say data refresh, is it between the power Bi data set that is created using desktop and power bi service, or when i do some update on sharepoint lists , will it automatically get reflected in my Online reports. Please confirm.

To test this functionality, i deleted few records in my sharepoint list. Then i refreshed my dataset in power bi desktop. Then i opened my Power Bi online and refreh the reports . And, it got reflected with the new data.

So what i understand is, this schedule refresh is bound to happen between the Power Bi desktop dataset and power bi online, and no where linked to the data in sharepoint online. so, if we want to get the latest data from sharepoint online, i should trigger a manual refresh in power bi desktop, which in turn triggers a schedule refresh or refresh now on power bi online to get the data reflected. Please correct me if i am wrong.

Thanks in advance.

Regards,

Sivapratap.

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

---

When we say data refresh, is it between the power Bi data set that is created using desktop and power bi service, or when i do some update on sharepoint lists , will it automatically get reflected in my Online reports. Please confirm.

---

If you do some update on sharepoint lists , it will automatically get reflected in your Online reports, usually within about an hour.

So what i understand is, this schedule refresh is bound to happen between the Power Bi desktop dataset and power bi online, and no where linked to the data in sharepoint online.

---

No, there're no interactions between data refresh on Power BI Desktop and data refresh on Power BI online. When a data refresh happens(no matter on Desktop or online), it uses information in the dataset to connect directly to the data sources(your SharePoint Lists in this scenario) to query for updated data it then loads into the dataset. 

For more details, please refer to Data refresh in Power BI.

Regards