Forum Discussion

jcichansky18's avatar
jcichansky18
Icon for Helper I rankHelper I
5 years ago

Gateway connection to Analysis Services

Hi,

 

I have a tabular cube, which is connected to SQL Server with admin role both in cube & SQL Server Analysis services engine. I also have technical user, with the same permissions as I have.

Then I connected Power BI Desktop to my tabular cube & deployed to PBI Service.

 

Technical SQL server account: domain\technicaluser

Connection (username) to PBI Service as [email protected]

Connection (username) to SQL Server as [email protected]

 

Within PBI Service we have installed Power BI Gateway (standard mode), running in a cluster. Gateway is up & running.

 

Now I want to view my report in PBI Service. 

  • GW connection is configured to use technical account (domain\technicaluser or corresponding email address) -> connection test OK, connection working
  • User tab of the connection = me ([email protected])
  • Map user names

 

Even though, when I open the report, I get following error message: 'This report couldn't access the data source. ...'

 

Gateway itself is working. I tested it with connection to SQL Server - import mode -> scheduled refresh worked just fine. Also for analysis services connection works scheduled refresh (used only for testing purposes).

 

Don't you know what am I missing?

 

Thanks

Need Help

7 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    5 years ago

    Hi jcichansky18 ,

     

    Within Desktop are using the same userid as you are using when you are in the service?  Also, are you using the same permission TYPE and PRIVACY LEVEL in your credentials?  This is in Desktop for the data source:

     

     

    • jcichansky18's avatar
      jcichansky18
      Icon for Helper I rankHelper I
      5 years ago

      Hello,

       

      Thanks for reply. Yeah, I have same privacy level. Regarding user name:

      PBI Desktop + Analysis Services engine + GW connection: [email protected] or corresponding domain\username

      PBI Service: [email protected]

       

      Therefore I'm remapping in GW connection settings.

       

      Thanks

      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        5 years ago

        HI jcichansky18 ,

         

        When you open the dataset on the Service, does it give more of an error message?  I am hoping for something like "credentials on source not correct" or something like that.  I have seen that now and then where the gateway is fine but for some reason the report itself, on the credentials needs to be updated.