Forum Discussion

jerish's avatar
jerish
Helper I
7 years ago
Solved

datasource access error to SSAS

I deployed ssas tabular from VS 2017 to Analysis Services 2016 and created a report from PBI Desktop using Live connection which all works great. Published it to a PBI workspace and when trying to ac...
  • jerish's avatar
    jerish
    7 years ago

    It was resolved by our IT dept. We had corporate domain which was different from our development domain and accorging to them they modified some forwarding settings . And I modified the effective user setting under manage gateway to map the email to an actual domain account.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

jerish Is the user that deployed the report an approved user for the data source in the gateway?

jerish's avatar
jerish
Helper I
7 years ago

Yes. I can create and report fromExcel Pivot table with no issues. I myself deployed the SSAS and the gateway is also running under my account. So I am sure it is not a privilege issue to the dataset

    • jerish's avatar
      jerish
      Helper I
      7 years ago

      If you are asking about the SSAS DB and Gateway, then they are now on the same machine to eliminate the odds. 

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        HI there

        If you can have Query Profiler running on your SSAS server and then try and access the report. It will give you an error when trying to connect.