Is it possible for PBI to ingest data from multiple files

[Anonymous]

Hi All,

Can power BI ingest data like SSIS does, i can load hourly flat file data using for loop in SSIS, is there a way we can do that using SSIS?

Thanks

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[Greg_Deckler · Accepted solution]

@Anonymous Like a Folder query?

[Anonymous]

@Greg_Deckler Thanks. Not sure. . We have files ftp'd to our shared location every hour, what i want to do is refresh PBI every hour so that it picks up the latest file and loads the data. Currently we have an SSIS package that runs every hour and loads the data into a SQL Server table. SSRS gets the data from the table, we want to by pass SSIS if we can and do it all using PBI. Any ideas?

Thanks

[Anonymous]

Hi @Anonymous 

I think you mean that your data source will refresh every hour, so you want to refresh your Power BI Report every hour automaticlly as well.

Power BI Desktop doesn't support you to refresh it automaticlly, you can refresh your report in Power BI Desktop by click Refresh in above Navigation Bar.

You can publish your report to Power BI Service and you can use schedule refresh in Power BI Service to refresh your report automaticlly. If your use cloud data source, you don't need to install an on-premises gateway. You just need to configure the data source credential in dataset setting. If you use on-premises data source you need to install an on-premises gateway. You need to configure credential correctly in gateway and keep the PC with gateway and data source on to make your schedule refresh successfully.

Note: On-premises gateway has two version, persion version or standard version, choose it by your requirement.

For reference: 

What is an on-premises data gateway?

On-premises data gateway vs. on-premises data gateway (personal mode)

Install Gateway

For reference: Configure scheduled refresh

If you don't have premium license, your schedule refresh has time limitation to 8. You need premium license to break the limit of refresh times to 48.

Best Regards,
Rico Zhou

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

[Anonymous]

@Anonymous @Greg_Deckler Thanks for the insight.

Thanks