Resources publishing issue

[PierrickLux]

Using PowerBi reporting Services over SQL 2016:

When publishing Resources files (such as images), file extension is lost, and MimeType provided in CreateCatalogItem() is not identified as such by RS. Once uploaded, file is recognized as application/octet-stream.

The $fileName provided to CreateCatalogItem should contains the complete FileName (extension included). $fileName = [System.IO.Path]::GetFileNameWithoutExtension($_.FullName) + [System.IO.Path]::GetExtension($_.FullName);

Not sure the best to do it in Powershell :)

Still:, nice Tasks, thank you.

A few additional enhancements:

• Creating Target folder path would be nice to avoid having to create them manually
• Include the rdsFileCount and rsdFileCount as part of the if statement, otherwise we might have an error if path is invalid even though the checkbox is disabled.

[anton-kirschhock]

@PierrickLux Next week I have time to review your issue. (got a few deadlines this week). Ill keep you posted

[anton-kirschhock]

@PierrickLux You can now check the option "Add the extension to the resource files" in the advanced section.

Can you let me know if this is now resolved (could not test it 100%)

[anton-kirschhock]

@PierrickLux FYI, there is a new task, which can deploy the whole folderstructure you have on your local machine :)

[ygeelen-tb]

@PierrickLux Is this issue resolved?

[PierrickLux]

@ygeelen-tb Yep, perfect thx! I owe you a beer :)

[anton-kirschhock]

@PierrickLux You are welcome :). FYI Our address for the beer is: Tobania Corda Campus - Gebouw I Kempische steenweg 311 box 6.02 3500 Hasselt Belgium