Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following all the steps precisely on this page:

Configure PerformancePoint Services: http://technet.microsoft.com/en-us/library/ee748644.aspx

We opened the dashboard designer. Next we started to create a Data Source to an SSAS Tabular model, but when we expanded the database list it was empty. What? I have done this a million times over, what am I missing? I stopped and paused for a bit and somewhere in the back of my memory I remember installing ADMOMD.NET from the SQL Server SQL Server 2008 R2 Feature Pack. After the installed completed we reset IIS, restarted the dashboard designer, and the database list populated.

Hope this helps someone.

Talk to you soon,

Patrick LeBlanc