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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JohnySta
Frequent Visitor

Can't connect to Analisys Services. Sure to set correct connection string

Hello everybody .

Im new to Power BI Server and trying to run simple Power BI report with Data Connectivity mode (DirectQuery) from local MS SQL Server .

Using Power BI Desktop (January 2019) report shows data correctly. 

After installing gateway and publishing report  at app.powerbi.com report also shows data correctrly.

But when I try to run this report on local Power BI Server which uses data from local MS SQL Server I get an error message "Can't connect to Analisys Services. Sure to set correct connection string" 

Be obliged for any help, thanks for advance.

 

P.S. service  Analisys Services is already installed 

 

 

1 ACCEPTED SOLUTION

It's not Report Server topic because u don't have it...

 

It's Power Bi Desktop topic.

View solution in original post

5 REPLIES 5
JohnySta
Frequent Visitor

Screenshot_1.jpg

Windows FireWall is already disabled. 

It's not Report Server topic because u don't have it...

 

It's Power Bi Desktop topic.

Ok . I move it

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.