Skip to content

A couple of things to watch out for if deploying Power BI Report Server

Reading Time: 1 minute

A while back I wrote a blog post about how SQL Server DBA’s can make use of Power BI Report Server here. Therefore, I thought I better write about a couple of things to watch out for if you are deploying Power BI Report Server.

Database collations

To make things easier for yourself you might download a script or a Powershell module to automate Power BI deployments. If you do keep this an eye on your database collations. You might have to check the script and change the collation used to create the databases. Otherwise you might end up with an unexpected collation that can cause issues.

Unable to add Data Sources

Occasionally when you try to add a Data Source in the Power BI Report Portal you might get an error. To resolve this simply recreate your Virtual Directory in the PowerBI Report Manager. If you’re anything like me, you’ll probably want to rename it to anything else and then recreate it again as its original name.

Final word

Anyway, that’s it from me in this brief post. Feel free to comment below.

Published inBusiness Intelligence & analytics

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *