Refresh Fail - Folder Source

[Caitlin_Knox]

I have a PBIX file with a folder as the data source. The folder gets freshly exported csv files from a web service weekly. My expectation is that when the folder gets a new file added, the data modeling steps performed on the first will be applied to all subsequent.

I have published the pbix file to my dashboard and have set it to stay up to date. The actual pbix file lives on my one drive for business.

I am receiving the following error when refreshing on demand- I'm not sure what the error message means. Any help or pointers in the right direction are appreciated.

I should add that I am able to open the pbix file, and when I select refresh- it processes the data fine- and the visualizations are then up to date.

Refresh history

Details Type Start End Status Failure message

Hide	On demand	‎4‎/‎11‎/‎2016‎ ‎3‎:‎14‎:‎21‎ ‎PM	‎4‎/‎11‎/‎2016‎ ‎3‎:‎14‎:‎31‎ ‎PM	Failed	An error occurred while processing the data in the dataset.
Hide details Data source type:   Data source error: The Csv.Document parameter 'Columns' is invalid. Cluster URI: WABI-WEST-US-redirect.analysis.windows.net Activity ID: 9ba11e7f-e57d-0a7e-03c6-7581df25fc8d Request ID: 99d829ea-adaa-9c56-40cb-83c322f05bf4 Time: 2016-04-11 22:14:31Z

[Caitlin_Knox · Accepted solution]

Just adding this for posterity. I had a ticket open with Microsoft and worked through the issue- their response was finally this:

According to the product group there was an update issued for the gateway adapter service, which was deployed and addressed the issue.

Everythign is working as expected now.

[ankitpatira]

@Caitlin_Knox I have noticed issues with .csv files in powerbi for few times now. What i've then done and has worked for me is to import .csv as text files and then using query delimit columns by comma. Error have dropped since them and schedule refresh have also been fine.