Data Refresh on PBI Service

[ryan_b_fiting]

Hello - 

I am working with a client who only uses Mac's but wants to use Power BI as his BI Tool.  He has files that he saves to a Google Drive Folder (which I know there is not an easy connection to a FOLDER) and wants to use those files for his reporting.

I am trying to work out the easiest and most efficient way for me to create the reporting he needs in PBI Desktop, publish it to his PBI Service and then let him have the ability to refresh the data whenever he loads a new file into the folder in the cloud.

Is there a way that I can create a Sharepoint Online folder, share it with him and connect to that FOLDER to pull all of the files in and create the dashboards on,  and then, allow him to upload the new files to that folder and just refresh the reports in the PBI Service?

I am looking for a way to do this without my client having to use a VM, Parallels, Turbo.net or be dependant on me for a Gateway being connected to the internet.

I have been searching quite a bit for this and cannot find any sort of clear cut answer with this.

Any help is appreciated.

Thank You

Ryan F.

[V-pazhen-msft]

@ryan_b_fiting 

A well-known way is "Sharepoint Folder" connector and selecting your desired folder from the displaying list of folders' path.

Combining Excel Files hosted on a SharePoint folder with Power BI

However, you cannot just refresh new uploaded files to the dataset and create report. You must manual get the new uploaded files then publish to service to replace the origin dataset.

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Perhaps using Azure Blob storage or Azure File storage?