Connect to OneDrive folder instead of specific files

[heli]

Hi!

We have an application that writes a new CSV file every day and uploads it to a OneDrive folder.

Currently I use Power BI Desktop to load all files from that local OneDrive folder (filter rule) and the PBIX file is stored to OneDrive as well. The Power BI Dashboard connects to the PBIX file on OneDrive (with a scheduled refresh).

The problem is: Additional CSV files are not automatically loaded in the Dashboard unless I manually open the PBIX file, refresh the data and store the PBIX file again.

If I understood correctly, the Power BI Desktop could be connected to a OneDrive URL instead a local path. That way it might be possible that a Dashboard can automatically refresh data if the CSV content changed.

But since there are new CSV files every day, I would need to connect Power BI Desktop to a OneDrive folder instead of specific files.

Is there any way/trick to connect the Power BI to a OneDrive folder (that contains additional CSV files every day) ?

[v-jiascu-msft]

@heli

Hi,

According to your post, it seems that you already have a Gateway. It should work but a little slow. If you didn't have a Gateway, you can get one following the guide below.

1. If only PBI is active,  Power BI Gateway – Personal is enough. Install it in the computer in which the folder is located and sign in.
2. If the source is shared with other service like Power APP, On-premise Gateway is needed. Install it in the computer in which the folder is located and sign in. Add a data source in Power BI Service.

 

Best Regards!

Dale

[arvindyadav]

Hi @v-jiascu-msft,

Is there are a need for connecting with Gateway we are using Onedrive do there is no need of gateway.

Please suggest me best answer how can I upload several files as the @heli said in onedrive and it will work in power bi desktop.

Regards,

Arvind.

[v-jiascu-msft]

Hi @arvindyadav,

Please create a thread in this forum.

Best Regards,

Dale

[v-jiascu-msft]

Hi @heli,

Could you please mark this as answer if it worked? Most about this topic, please feel free to post here.

Best Regards!

Dale