March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
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
Then in the "Advanced" tab edit the AllowedResourceExtensionsForUpload property and add ,*.csv to the end of this list.
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
Then in the "Advanced" tab edit the AllowedResourceExtensionsForUpload property and add ,*.csv to the end of this list.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
11 | |
5 | |
5 | |
4 | |
4 |