Forum Discussion

l2aFa's avatar
l2aFa
Icon for Helper I rankHelper I
8 years ago

Power BI service dataset (SSAS source) help

Hello everyone

 

I have created a Power BI dataset in my service which connects to an SSAS Tabular Live Connection source. 

 

I've developed a report using that deployed Power BI service dataset and the report just works fine inside my development machine which has the Power BI gateway installed and configured in my PBI account.

 

Whenever I try to open that report from outside the development machine (my personal laptop), I get this error:

 

 

I'm able to connect to the development machine (from my laptop) using an Analysis Services connection just fine, however the same error shows when I try to connect to that dataset (or any existing other with SSAS as a source) using the Power BI service connector.

 

Is there any problem in connecting through the Power BI service when the dataset source is an Analysis Services connection?

 

I found this article about this particular scenario but its from april. I don't know if the situation has changed: https://powerbi.microsoft.com/es-es/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop/

 

I have another report which is working fing using the Power BI Service connection but its against a Direct Query source. Could it be that the SSAS data sources arent still supported? Does anyone know a possible fix?

 

Thank you very much in advance!

 

 

 

 

 

Need Help

2 Replies

  • sgsukumaran's avatar
    sgsukumaran
    Icon for Resolver II rankResolver II
    8 years ago

    Lets run through the scenarios

     

    Works In dev Box and not in Personal  machine

     

    1. When you run from the dev machine are connecing using service account or personal account. You can run a trace against SSAS to see which account is being logged from. That should be your start.

     

    2. Is your SQL Server and POwerbi on the same domain?

     

    3. Also try to add yourself at the server level and see if you can connect from your Local machine.

     

    Connect to SQL Servers in another domain using Windows Authentication

    • l2aFa's avatar
      l2aFa
      Icon for Helper I rankHelper I
      8 years ago

      Hi sgsukumaran

       

      Thanks for your response. As for your questions.

       

      1. I'm using a domain account. I can connect to the dev machine without a problem from my laptop if I employ the Analysis Services data source but when I try to connect through the Power BI service it fails. Will try the trace though.

       

      2. Nope and I don't know if them can be. My Power BI Gateway and SSAS instance are on the same machine. The Power BI user is configured to be replaced by a domain user with admin permissions whenever Power BI interacts with my SSAS model, as I said, there is no problem connecting directly to the SSAS source from outside, the problem manifests when I try to connect via the Power BI Service.

       

      3. The domain user configured in the Power BI account has administrator permissions on the entire SSAS instance. I algo have configured that same user credentials within my laptop (Windows credentials)  whenever I interact with that server. For the time being, I think the problem is with the Power BI Service connector and not with SSAS permissions/access.

       

      Thank you very much.