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
Anonymous
Not applicable

Q&A Performance on Power BI Service

I have a fairly simple data model with about 10 related tables and low data volumes (the largest table is 2.5K rows). I have a Q&A visualization that performs well in Power BI Desktop, with answers being rendered almost instantaneously. 

 

The central problems is that when we publish the Q&A visualization to the Power BI Service, performance is poor. The same questions that Desktop answers almost instanteously may take 30 seconds to several minutes to render, and often time out with an error saying "We couldn't answer your question due to a network issue. Check your network connection and try again." I believe the error message is a red herring as I doubt the issue is truly network-related. I have asked a question, received the error, republished the Q&A visualization with all tables turned off in the Field synonyms set-up screen other than the ones this question requires, and gotten a result with the same question. I have also monitored CPU usage on my Azure capacity and haven't seen anything above about 10% utilization. I have also checked the data model to ensure there are no weird cartesian joins or anything that would cause unexpected bloat in the data. 

 

Anecdotally, it seems like the performance started fine when we first published this visualization, and has degraded over time to the point of being unusable. I know this isn't due to large swings in data volumes as this data model is based on demo data that is static except for the dates which are rolled forward once per week to make the data seem current. 

 

So, my questions:

 

  1. Is there a way to troubleshoot performance in the Power BI Service since the performance issues don't show up in the performance analyzer in Desktop?
  2. Do you have any hints that you can share to make the Q&A more performant in the Power BI Service?
  3. Is there a way of "resetting" the machine learning model in the Power BI Service to see if that is the cause of the performance degradation over time? 

Thanks in advance.

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @Anonymous 

 

Just to clarify are you using Imported mode or DQ mode with your dataset?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi,

 

Wanted to surface this again to see if anyone else had additional ideas here? This continues to be a problem for us. If not, are there other channels we can turn to to get additional guidance? 

 

Thanks in advance. 

Anonymous
Not applicable

I am using imported data, not direct query. 

Hi @Anonymous 

 

Are you using the latest version of Power BI Desktop?

 

Also are your measures in a seperate measure table or in the fact tables?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi GilbertQ,

 

Thanks for helping out. I'm using the latest version of Desktop. My use case is simple. Just an aggregation of a numerical field on a fact table. 

 

Thanks

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors