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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
mike_honey
Memorable Member
Memorable Member

Error accessing PPU workspace General properties using SSMS

Using SQL Server Management Studio (SSMS), I am able to connect to my Premium-Per-User (PPU) workspace. However I want to review and edit the timeout settings, which are on the General tab of the workspace Properties dialog.

 

I always get this error when I choose the General tab:

 

The Analysis Services server administrator role is not supported in Power BI. Please use the Power BI security model instead.

 

I am trying to follow the advice from this blog post:
https://powerbi.microsoft.com/en-us/blog/analysis-services-server-properties-in-power-bi-premium-are...

4 REPLIES 4
mike_honey
Memorable Member
Memorable Member

Actually, for PPU there is nothing shown in the Power BI Admin Portal under Capacity Settings. That only shows Premium Capacity. 

Hi,

 

Please refer this post-

Power BI - Granular control with Analysis Services server properties

https://www.linkedin.com/pulse/power-bi-granular-control-analysis-services-server-romain-casteres?ut...

 

I hope it will be helpful.

 

Screenshot_2024-05-22-22-52-10-86_254de13a4bc8758c9908fff1f73e3725.jpg

hackcrr
Super User
Super User

Hi, @mike_honey 

You can manage your PPU capacity in the admin portal of Power BI Service, as shown in the following figure:

hackcrr_0-1715992749068.png

hackcrr_1-1715992774144.png

 

You can connect to your semantic model through Power BI desktop by going to File > Options and Settings > Data Source Settings, where you can modify the data source settings, including the timeout‘’

hackcrr_2-1715992893106.png

If you need to adjust advanced settings such as timeouts, consider using PowerShell scripts or the XMLA endpoint. The XMLA endpoint allows for advanced configuration and management of datasets in Power BI.

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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