KNOWLEDGE BASE

View with Live Connection to MSAS Is Blank and Does Not Show Any Data After Publishing


Published: 09 Apr 2014
Last Modified Date: 27 Oct 2015

Issue

When viewing a workbook published to Tableau Server with a live connection to a MSAS database, views might be blank and not contain any data. No error message is displayed.

Environment

  • Tableau Server
  • MSAS

Resolution

Option 1

Edit the MSAS connection and specify the credentials manually using Tableau Desktop. When publishing, choose to embed the database credentials, or choose to prompt other users for their MSAS password.

Option 2

Grant the Tableau Server Run As account appropriate permissions to access data in the MSAS database.

Cause

Tableau Server Run As account has access to connect to the database, but does not have privileges to access the data.
Did this article resolve the issue?