cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andyw324 Frequent Visitor
Frequent Visitor

Automated CSV Uploads via API no longer allowed in May 2019 version

I am currently testing out the May 2019 version of Power BI Report Server and am encountering an issue when uploading CSVs via the SOAP API (using reportserice2010.asmx).

 

We have a daily SSIS job that generates data and uploads the reults to Power BI Report Server using the CreateCatalogItem function to post a csv (converted into a binary stream) as a application/octet-stream MIME Type. This works fine on PBIRS August 2018 but with the May 2019 update the following error is returned:

 

Uploading or saving files with .csv extension is not allowed. Contact your administrator if you have any questions

 

I know our setup maybe fairly unique but has anyone else encountered this and found a resolution?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Automated CSV Uploads via API no longer allowed in May 2019 version

They added extra security to the allowed file extensions in the Jan 2019 release. You can add extra extensions to the allowed list using SSMS. Connect to http://yourserver/reports in the SSMS object explorer

 

Then right click on the server and choose properties

201906 allow csv1.png

 

Then in the "Advanced" tab edit the AllowedResourceExtensionsForUpload property and add ,*.csv to the end of this list.

 

201906 allow csv2.png

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Automated CSV Uploads via API no longer allowed in May 2019 version

They added extra security to the allowed file extensions in the Jan 2019 release. You can add extra extensions to the allowed list using SSMS. Connect to http://yourserver/reports in the SSMS object explorer

 

Then right click on the server and choose properties

201906 allow csv1.png

 

Then in the "Advanced" tab edit the AllowedResourceExtensionsForUpload property and add ,*.csv to the end of this list.

 

201906 allow csv2.png

View solution in original post

andyw324 Frequent Visitor
Frequent Visitor

Re: Automated CSV Uploads via API no longer allowed in May 2019 version

Thanks for the detailed walk through of the fix. Completely missed that addition in the release notes as the Jan 2019 update was not applied and jump straight to the May 2019 release notes. :D.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 380 members 3,957 guests
Please welcome our newest community members: