Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Falt File connection

Hi

I know how to made connection of flat file with Power BI. Is it possible to automate updated flat file in Power BI for making Reports. For example : I have a requirement like  flat file will come in daily basis, so on this basis the report get updated automatically based on updated flat file.

 

Also, based on above requirement is it possible with REST Api?

 

Thanks in advance.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

You can create a folder to contain these history file and updated file, then connect to this folder in Power BI desktop and use Combine Files feature. Please make sure file type and structure of these files are the same. Then you can click on Refresh in Power BI desktop or set schedule refresh for the dataset in Power BI service to get updated data. See: https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable

Hi

 Thank you for your response it helpfull for me. I need help for On-premises data gateway. I was connection with On-premises data gateway and set all setting on Power BI service create data source and set the schedule time but when new file update in floder schedule was failed gave me this type of error "POC_FlatFile has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support." Is it necessary to use On-premises data gate (Personal Mode) because I am using On-premises data gateway .

 

Thanks In advance.