Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

Data source connection issue

Hi, I have installed today Power BI report server and published two reports with SSAS on Azure as data source. I set my credential to data source on webportal manage report, connection test was succ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Marcin,

 

When you mention you get data from "SSAS on Azure", do you mean it's Azure analysis services or SSAS instance installed in Azure VM?

 

Best Regards,
Qiuyun Yu

  • Marcin's avatar
    Marcin
    Helper V
    9 years ago

    Hi,

     

    I use Azure analysis services , we don't have any on-prem  serwers at this moment in my organization or VMs. 

     

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi Marcin,

       

      Was this Azure Analysis Service model created from the on-premise SQL database or Azure SQL database? If it's Azure SQL database, based on my test the report can display with correct database credential entered. If it's on-premise database, please try to set gateway and make gateway online: On-premises data gateway.

       

      By the way, please try to run Power BI report server GA version 14.0.600.286.

       

      Best Regards,
      Qiuyun Yu

      • Marcin's avatar
        Marcin
        Helper V
        9 years ago

        Hi,

         

        this Analysis Services Azure model is created from Database that is also Azure Cloud Database. Maybe the reason is that I don't have access to that Database from home, but I have access to Analysis Services with the same credentials. 

         

        I am using current version Power BI server