How to Connect to an Analysis Services Database in Power BI

  • Comments posted to this topic are about the item How to Connect to an Analysis Services Database in Power BI

  • This works for a simple situation but problems may arise in many enterprise situations.

    Many enterprises use DNS aliases for connection, as this gives a layer of indirection between PowerBI and the AS instance. In a HA failover situation it is necessary to quickly reconnect PowerBI to the new live server and aliases can help with this as all that should be needed is to update the alias. However this can be a problem.

    We found a problem that MS were not able to resolve. Most applications resolve the alias to the physical server name and generate a SPN based on the server name. The SPNs needed for this are documented and easy to set up. Unfortunately PowerBI does not do this resolution and attempts to connect using the alias name. The SPNs needed in this situation were not documented and although we tried many possibilities we could not get PowerBI to connect to AS using an alias. MS support also could not resolve this.  If anyone has tried this and got it working please add to this post.

    • This reply was modified 2 years, 2 months ago by  EdVassie.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply