Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Fail to use a dataset in the pbi service that uses a gateway to a on premise analytic service

Hi !
We have a on-prem Analysis Server (Tabular) with a gateway installed that cloude PBI reports consume.
It works fine to create new reports when on the PBI server.
Now i'm trying to use PBI Desktop to reache the SSAS model. I'm trying to connect my PBI desktop to a PBI datasets in the cloud and after a while it returns. -

"Details: Power BI service live connection is invalid...
 Details: We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."  
I have upgraded the gateway and the desktop but no success.

Any suggestions? 

Best regards /Pelle

Community Support
Community Support

Hi @PelleTheSwede 


What is the way you Get Data in Desktop? Power BI datasets or Analysis Service? What is the connection mode of your data?


Besides, here are some documents that may help you:

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Docs


Best Regards,

Jianbo Li

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



Hi Jianbo Li!
I'm trying the Power BI DataSet and I have turned on the preview feature "DirectQuery for PBI dataset and AS" but no success.
It says in the documentation that "With DirectQuery for Power BI datasets and Analysis Services, you can use DirectQuery to connect to Power BI datasets, Azure Analysis Services (AAS), and SQL Server 2022 (CTP) Analysis Services" and of course we use SQL Server 2017. So I guess we have some job to do....

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors