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.
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.
Anyway, that’s it from me in this brief post. Feel free to comment below.