Forum Discussion

psraghu's avatar
psraghu
Regular Visitor
7 years ago

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 ser...
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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