Data source folder

[Anonymous]

Hi ,

Im new to Power BI and trying to set up a dashboard to update as files dropped in folder automatically.

I set up a dashboard with a folder as data source. Is there a way to set Power BI to recongize a new file in the folder and refresh data in dashabord based on new file droppign in the folder?

Also has anybody used sub folder with different query steps on each folder successfully?

Thanks 

[Anonymous · Accepted solution]

you can achieve refereshing with scheduled refresh

However, the scheduled refresh is fixed so it only happens at the time you've selected - and it is limited to 8 refreshes per day for free and pro users and 48 refreshes a day for premium users.

If you want to "force" a refresh every time data is changed, make a Flow with Microsoft Flow. This solution requires you to make a PowerBI custom connecter in Microsoft Flow. and I got it done with easy-to-follow instructions from this blog. I needed a similar refreshing feature for one of my reports and the only solution I found was making a Flow with Microsoft Flow and creating a custom Power BI connector to Flow. Please note, that the 8 or 48 refreshes a day limit still exists even if you use Flow.

Also PowerBI supports straming (live) data sets that might meet you needs but there are limitaitons. 

Answer found here: https://community.powerbi.com/t5/Desktop/Can-power-bi-refresh-data-automatically-when-new-data-comes...

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can load the folder files using folder connector in power bi desktop and then use Combine files(binaries)" behaviour in power query.

With the behavior of Combine files(binaries), you can easily combine all files within a given folder, as long as they have the same file type and structure (such as the same columns).

In addition, you can easily apply additional transformation or extraction steps by modifying the automatically created exemplar query, without having to worry about modifying or creating additional function query steps. Any changes to the exemplar query are automatically generated in the linked function query.

Community Support Team _ Jimmy Tao

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

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can load the folder files using folder connector in power bi desktop and then use Combine files(binaries)" behaviour in power query.

With the behavior of Combine files(binaries), you can easily combine all files within a given folder, as long as they have the same file type and structure (such as the same columns).

In addition, you can easily apply additional transformation or extraction steps by modifying the automatically created exemplar query, without having to worry about modifying or creating additional function query steps. Any changes to the exemplar query are automatically generated in the linked function query.

Community Support Team _ Jimmy Tao

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

[Anonymous · Accepted solution]

you can achieve refereshing with scheduled refresh

However, the scheduled refresh is fixed so it only happens at the time you've selected - and it is limited to 8 refreshes per day for free and pro users and 48 refreshes a day for premium users.

If you want to "force" a refresh every time data is changed, make a Flow with Microsoft Flow. This solution requires you to make a PowerBI custom connecter in Microsoft Flow. and I got it done with easy-to-follow instructions from this blog. I needed a similar refreshing feature for one of my reports and the only solution I found was making a Flow with Microsoft Flow and creating a custom Power BI connector to Flow. Please note, that the 8 or 48 refreshes a day limit still exists even if you use Flow.

Also PowerBI supports straming (live) data sets that might meet you needs but there are limitaitons. 

Answer found here: https://community.powerbi.com/t5/Desktop/Can-power-bi-refresh-data-automatically-when-new-data-comes...

[Anonymous · Accepted solution]

Thanks once I got my gateway running the refresh imported the data and displayed as expected thansk for your help.