Forum Discussion

jinligang's avatar
jinligang
Frequent Visitor
6 years ago

How to connet SQL Server Analysis Services by Power BI Dataset?

Hi,

I have a Power BI dataset that connect the SQL Server Analysis Services by Power BI Gateway.


When I create a report with the dataset, 'Get Data'-->'Power Platform'-->'Power BI datasets'. I can find the dataset.
When I click the 'Create' button to connect the dataset, the error appear:


the server name ,'localhost/tab14', is the VM of Azure VNET, but I can not connect the server with my home network.

 

Why I must connect the Analysis Services direct instead of by the Power BI Dataset?

 

Thanks.

Jin Ligang

 

Need Help

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, jinligang 

     

    I'd like to suggest you refer the official document . Do pay attention to the limitations and considerations. Hope it helps.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    I would recommend the way to work on this is to do it by developing on the Power BI Gateway VM.

    I would also suggest to change the name from LOCALHOST to the actual server name. This will allow you to also ensure that you can connect remotely.