Forum Discussion

tiago's avatar
tiago
Helper I
10 years ago

Connect to SQL Sever with On-Premisses data gateway

Hi guys,
I am a beginner to Power BI and I am trying to connect my SQL Server so I can use it as a data set. From what I heard I needed to install the On-premises data gateway and they configure a gateway on the WEB interface and then add a Data Source.
I successfully connected to my data base and I receive the Connection Successful check when I click test all connections.
But when I go to Datasets – SQL Server Analysis Services – Connect
There is no server listed there for me to connect – (No resources found). I triend to look up for this and saw in a tutorial that this could be that my user didn’t have permission to access any database. But my user was automatically added on the Users tab on Data Source Settings.
I don’t have the desktop app installed. I was trying to connect to my database from the web interface directly.
What did I miss, someone know how I can access my database after the gateway is configured ?
Regards,
Tiago

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    10 years ago

    There are layers of complexity, so I recommend you try to break the problem in parts.

     

    Your post refers to SQL server and then Analysis services. Are you aware these are not the same things?

     

    Assuming you do, download the power bi desktop app and try to connect to your SSAS DB. Doing this isolates any DB connection issues from any gateway issues. If that works, publish the workbook to the power bi service and check again. You need to be an administrator of the gateway to be allowed to publish workbooks that connect back to your server. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi tiago,

    Do you want to connect directly to SQL Server Analysis Services databases from Power BI Service? If that is this case, please ensure that you add a SSAS data source to the gateway. There is an example for your reference, please make sure that the data source type is set to Analysis Services rather than SQL Server, and ensure that your account is added in Users tab in the following screenshot.

     

    After that, you should be able to connect to SSAS database from Get Data>Databases>Get in Service.

     


    However, if you want to connect to SQL Server databases, you would need to first use Power BI Desktop connect to, query, and load data into a data model, create reports and then publish your Power BI Desktop file into Power BI Service.

    Thanks,
    Lydia Zhang