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

[jinligang]

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

[GilbertQ]

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.

[v-alq-msft]

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.