Workspace OneDrive

[kannanAhammed]

Hello, 

I was exploring this option on power bi. While testing it out i have understood that, you can add office 365 groups. Few doubts i have is as below.

1) Will the power bi able to access files from this group.

2) I was told there is no need to schedule refresh and it will auto sync when ever there is a change in the data sourse such as excel etc...

If you can give me an overall Idea that will be great. 

If auto sync works this will be the best option i can use for a dashboard i have created with excel as the data source  and i dont have to schedule refresh which i can only do up to 8 times a day with my pro license.

[v-lili6-msft]

hi  @kannanAhammed 

For onedrive refresh, you could refer to this document:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#onedrive-refresh

By the way, If the pbix file is published to power bi service by power bi desktop(Publish), there will no onedrive refresh in dataset setting 

Only pbix file is get data in power bi service , or get data from a excel in onedrive in power bi service, there will be onedrive refresh

and for newworkspace, please see how to set workspcae onedrive:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-the-new-workspaces#set-a-...

Regards,

Lin

[amitchandak]

@kannanAhammed , Change detection is there. It is more for Direct query , check out

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_CDM

Also, refer

https://www.youtube.com/watch?v=qu6O2ySCeOA

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