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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
psraghu
Regular Visitor

PowerBi report with SSAS tabular model CPU utilization reaches to 100%

Hi Expersts,

 

Power BI Report fetches the data from SSAS tabular model   and report has two filters.

Whenever user unchecks the paramters in the report thenCPU utliazation reaches to 100% and server is restarting.

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi psraghu,

 

Based on your description, you are using "import", right? What about the dataset size in your tabular model? Please refer to the dataset size limitation such as rows and columns: https://docs.microsoft.com/en-us/power-bi/service-get-data#considerations-and-limitations. In addtion, please check if your server meet the requirement to run power bi desktop, check the configuration below:

  • Windows 7 / Windows Server 2008 R2, or later
  • .NET 4.5
  • Internet Explorer 9 or later
  • Memory (RAM): At least 1 GB available, 1.5 GB or more recommended.
  • Display: At least 1440x900 or 1600x900 (16:9) recommended. Lower resolutions such as 1024x768 or 1280x800 are not recommended, as certain controls (such as closing the startup screen) display beyond those resolutions.
  • Windows Display settings: If your display settings are set to change the size of text, apps, and other items to more than 100%, you may not be able to see certain dialogs that must be closed or responded to in order to proceed using Power BI Desktop. If you encounter this issue, check your Display settings by going to Settings > System > Display in Windows, and use the slider to return display settings to 100%.
  • CPU: 1 gigahertz (GHz) or faster x86- or x64-bit processor recommended.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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