Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PelleTheSwede
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

2 REPLIES 2
v-jianboli-msft
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?

vjianbolimsft_0-1662104957344.png

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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors