Power BI adoption roadmap: User support

Note

This article forms part of the Power BI adoption roadmap series of articles. For an overview of the series, see Power BI adoption roadmap.

This article addresses user support. It focuses primarily on the resolution of issues.

The first sections of this article focus on user support aspects you have control over internally within your organization. The final topics focus on external resources that are available.

For a description of related topics, including skills mentoring, training, documentation, and co-development assistance provided to the internal Power BI user community, see the Mentoring and user enablement article. The effectiveness of those activities can significantly reduce the volume of formal user support requests and increase user experience overall.

Types of user support

If a user has an issue, do they know what their options are to resolve it? The following diagram shows some common types of user support that organizations employ successfully:

Image shows the four types of internal Power B I user support, and the two types of external support, which are described in the table below.

The six types of user support shown in the above diagram include:

Type Description
Type 1. Intra-team support (internal) is very informal. Support occurs when team members learn from each other during the natural course of their job.
Type 2. Internal community support (internal) can be organized informally, formally, or both. It occurs when colleagues interact with each other via internal community channels.
Type 3. Help desk support (internal) handles formal support issues and requests.
Type 4. Extended support (internal) involves handling complex issues escalated by the help desk.
Type 5. Microsoft support (external) includes support for licensed users and administrators. It also includes comprehensive Power BI documentation.
Type 6. Community support (external) includes the worldwide community of Power BI experts, Microsoft Most Valued Professionals (MVPs), and enthusiasts who participate in forums and publish content.

In some organizations, intra-team and internal community support are most relevant for self-service BI (content is owned and managed by creators and owners in decentralized business units). Conversely, the help desk and extended support are reserved for technical issues and enterprise BI (content is owned and managed by a centralized business intelligence team or Center of Excellence). In some organizations, all four types of support could be relevant for any type of content.

Each of the four types of internal user support introduced above are described in further detail in this article.

Intra-team support

Intra-team support refers to when team members learn from and help each other during their daily work. People who emerge as your Power BI champions tend to take on this type of informal support role voluntarily because they have an intrinsic desire to help. Although it's an informal support mode, it should not be undervalued. Some estimates indicate that a large percentage of learning at work is peer learning, which is particularly helpful for analysts who are creating domain-specific Power BI solutions.

Note

Intra-team support does not work well for individuals who are the only data analyst within a department. It's also not effective for those who don't have very many connections yet in their organization. When there aren't any close colleagues to depend on, other types of support, as described in this article, become more important.

Internal community support

Assistance from your fellow community members often takes the form of messages in a discussion channel or forum set up specifically for this purpose. For example, someone posts a message that they're having problems getting a DAX calculation to work. They then receive a response from someone in the organization with suggestions or links.

Tip

The goal of an internal Power BI community is to be self-sustaining, which can lead to reduced formal support demands and costs. It can also facilitate managed self-service BI occurring at a broader scale versus a purely centralized BI approach. However, there will always be a need to monitor, manage, and nurture the internal community. Here are two specific tips:

  • Be sure to cultivate multiple experts in the more difficult topics like Data Analysis eXpressions (DAX) and the Power Query M formula language. When someone becomes a recognized expert, they may become overburdened with too many requests for help.
  • A greater number of community members may readily answer certain types of questions (for example, report visualizations), whereas a smaller number of members will answer others (for example, complex DAX). It's important for the COE to allow the community a chance to respond yet also be willing to promptly handle unanswered questions. If users repeatedly ask questions and don't receive an answer, it will significantly hinder growth of the community. In this case, a user is likely to leave and never return if they don't receive any responses to their questions.

An internal community discussion channel is commonly set up as a Teams channel or a Yammer group. The technology chosen should reflect where users already work, so that the activities occur within their natural workflow.

One benefit of an internal discussion channel is that responses can come from people that the original requester has never met before. In larger organizations, a community of practice, which brings people together based on a common interest, can offer diverse perspectives for getting help and learning in general.

Use of an internal community discussion channel allows the Center of Excellence (COE) to monitor the kind of questions people are asking. It's one way the COE can understand the issues users are experiencing (commonly related to content creation, but it could also be related to consuming content). Monitoring the discussion channel can also reveal additional Power BI experts and potential champions who were previously unknown to the COE.

Important

It's a best practice to continually identify emerging Power BI champions, and to engage with them to make sure they're equipped to support their colleagues. As described in the Community of practice article, the COE should actively monitor the discussion channel to see who is being helpful. It should deliberately encourage and support them, and if appropriate, invite them into the champions network.

Another key benefit of a discussion channel is that it's searchable, which allows other people to discover the information. It is, however, a change of habit for people to ask questions in an open forum rather than private messages or email. Be aware that some individuals will not be comfortable asking questions in such a public way because it openly acknowledges what they don't know, which might be embarrassing. This reluctance may reduce over time by promoting a friendly, encouraging, and helpful discussion channel.

Tip

You may be tempted to create a bot to handle some of the most common, straightforward questions from the community. A bot can work for uncomplicated questions such as "How do I request a Power BI license?" or "How do I request a workspace?" Before taking this approach, consider if there are enough routine and predictable questions that would make the user experience better rather than worse. Often, a well-created FAQ (frequently asked questions) works better, and it's faster to develop and easier to maintain.

Help desk support

The help desk is usually operated as a shared service, operated by the IT department. People who will likely rely on a more formal support channel include those who are:

  • Less experienced with Power BI.
  • Newer to the organization.
  • Reluctant to post a message to the internal discussion community.
  • Lacking connections and colleagues within the organization.

There are also certain technical issues which cannot be fully resolved without IT involvement, like software installation and upgrade requests when machines are IT-managed.

Busy help desk personnel are usually dedicated to supporting multiple technologies. For this reason, the easiest types of issues to support are those which have a clear resolution and can be documented in a knowledgebase, like software installation prerequisites. Some organizations task the help desk to handle only very simple break-fix issues, whereas other organizations have the help desk get involved with anything that is repeatable, like new workspace requests, managing gateway data sources, or requesting new Premium capacities.

Important

Your Power BI governance decisions will directly impact the volume of help desk requests. For example, if you choose to limit workspace creation permissions in the tenant settings, it will result in users submitting help desk tickets. While it's a legitimate decision to make, you must be prepared to satisfy the request very quickly, usually within 1-4 hours if possible. Consider that automation with Power Apps and Power Automate can help make the process efficient. If you delay too long, users will use what they already have, and that may not be the ideal scenario. Promptness is critical for certain help desk requests.

Over time, troubleshooting and problem resolution skills become more effective as help desk personnel expand their knowledgebase and experience with Power BI. The best help desk personnel are those who have a good grasp of what users need to accomplish with Power BI.

Tip

Purely technical issues, for example data refresh failure or the need to add a new user to a gateway data source, usually involve straightforward responses associated with a service level agreement. For instance, there may be an agreement to respond to blocking issues within one hour and resolve them within eight hours. It's generally more difficult to define service level agreements (SLAs) for troubleshooting issues, like data discrepancies.

Extended support

Since the COE has deep insight into how Power BI is used throughout the organization, they're a great option for extended support should a complex issue arise. Involving the COE in the support process should be by an escalation path.

Managing requests as purely an escalation path from the help desk gets difficult to enforce since COE members are often well-known to business users. To encourage the habit of going through the proper channels, COE members should redirect users to submit a help desk ticket. It will also improve the data quality for analyzing help desk requests.

Microsoft support

In addition to the internal user support approaches discussed in this article, there are valuable external support options directly available to Power BI users and administrators that shouldn't be overlooked.

Microsoft documentation

Check the Power BI support site high-priority issues that broadly affect all customers. Global Microsoft 365 administrators have access to additional support issue details within the Microsoft 365 portal.

Monitor the Microsoft 365 Twitter account. Microsoft posts timely information and updates about outages for all Microsoft 365 services.

Refer to the comprehensive Power BI documentation. It's an authoritative resource that can aid troubleshooting and search for information. You can prioritize results from the Power BI documentation site. For example, enter a site-targeted search request into your web search engine, like "power bi dataset site:docs.microsoft.com".

Power BI Pro and Premium Per User end-user support

Users with a Power BI Pro or Premium Per User license are eligible to log a support ticket with Microsoft.

Tip

Make it clear to your internal user community whether you prefer technical issues be reported to the internal help desk. If your help desk is equipped to handle the workload, having a centralized internal area collect user issues can provide a superior user experience versus every user trying to resolve issues on their own. Having visibility and analyzing support issues is also helpful for the COE.

Administrator support

There are several support options available for global and Power BI administrators.

For customers who have a Microsoft Unified Support contract, consider granting help desk and COE members access to the Microsoft Services Hub. One advantage of the Microsoft Services Hub is that your help desk and COE members can be setup to submit and view support requests.

Worldwide community support

In addition to the internal user support approaches discussed in this article, and Microsoft support options discussed previously, you can leverage the worldwide Power BI community. This option is useful when a question can be easily understood by someone not close to the problem, and when it doesn't involve sensitive data.

Publicly available community forums

There are several public Power BI community forums where users can post issues and receive responses from any Power BI user in the world. It can be very powerful and exceedingly helpful. However, as is the case with any public forum, it's important to validate the advice and information posted on the forum.

Publicly available discussion areas

It's very common to see people posting Power BI technical questions on platforms like Twitter. A quick look at the #PowerBI hashtag reveals a vibrant global community of Power BI enthusiasts. You will find discussions, post announcements, and users helping each other. The #PowerBIHelp hashtag is sometimes used, though less frequently.

Community documentation

The Power BI global community is vibrant. Every day, there are a great number of Power BI blog posts, articles, webinars, and videos published. When relying on community information for troubleshooting, watch out for:

  • How recent the information is.
  • Whether the situation and context of the solution found online truly fits your circumstance.
  • The credibility of the information being presented.

Considerations and key actions

Considerations and key actions you can take to improve your intra-team support:

  • Provide recognition and encouragement to your Power BI champions, as well as incentives, as described in the Community of practice article.
  • Reward and praise meaningful grassroots efforts when you see them happening.
  • If informal intra-team efforts aren't adequate, consider formalizing the roles you want to enact in this area, and the expected contributions and responsibilities.

Considerations and key actions you can take to improve your internal community support:

  • Encourage people to ask questions in the designated community discussion channel. As the habit builds over time, it will become normalized to use that as the first option. Over time, it will evolve to become more self-supporting.
  • Ensure that the appropriate COE members actively monitor this discussion channel. They can step in if a question remains unanswered, improve upon answers, or make corrections when appropriate. They can also post links to additional information to raise awareness of existing resources. Although the goal of the community is to become self-supporting, it still requires dedicated resources to monitor and nurture it.
  • Make sure your user population knows the internal community support area exists. It could include the prominent display of links, or including a link in regular communications. You can also customize the help menu links in the Power BI service to direct users to your internal resources.
  • Set up automation to ensure that all your Free, Power BI Pro, and Premium Per User licensed users automatically have access to the community discussion channel. It's possible to automate license setup using group-based licensing.

Considerations and key actions you can take to improve your internal help desk support:

  • Determine the initial scope of Power BI topics that the help desk will handle.
  • Assess the readiness level of your help desk to handle Power BI support.
  • Arrange for additional training for help desk staff, based on readiness gaps.
  • Determine what the escalation path will be for requests the help desk cannot directly handle.
  • Update the help desk knowledgebase for known Power BI topics. Ensure someone is responsible for regular updates to the knowledgebase to reflect new and enhanced features over time.
  • Ensure a good issue tracking system is in place. It's often a ticketing system that can manage priority levels.
  • Decide if anyone will be on-call for any issues related to Power BI. If appropriate, ensure the expectations for 24/7 support are clear.
  • Determine what SLAs will exist, and that expectations for response and resolution are clearly communicated.
  • Be prepared to address specific common issues extremely quickly. For example, a request to add a new gateway data source should be handled very quickly (to avoid user frustration, and to minimize use of personal gateways as a workaround). Slow support response may result in users finding workarounds.

Considerations and key actions you can take to improve your internal COE extended support:

  • Clearly define where help desk responsibilities end, and where COE extended support responsibilities begin.
  • Ensure that COE members have a direct escalation path to reach global administrators for Microsoft 365 and Azure. It's critical when a widespread issue arises that's beyond the scope of Power BI.
  • Create a feedback loop from the COE back to the help desk so that the IT knowledgebase can be updated. The goal is for the primary help desk personnel to continually become better equipped at handling more issues in the future.
  • Create a feedback loop from the help desk to the COE. When support personnel observe redundancies or inefficiencies, they can communicate that information to the COE, who might choose to improve the knowledgebase or get involved (particularly if it relates to governance or security).

Maturity levels

The following maturity levels will help you assess the current state of your Power BI user support:

Level State of Power BI user support
100: Initial Individual business units find effective ways of supporting each other, though tactics are siloed and not consistently applied.

An internal discussion channel is available, but it's not monitored closely so the user experience is inconsistent.
200: Repeatable The importance of intra-team support is encouraged and actively supported by the COE, including direct support of the champions network.

The internal discussion channel gains traction as the default place for Power BI Q&A.

The help desk handles a small number of the most common Power BI technical support issues.
300: Defined The internal discussion channel is now popular and largely self-sustaining. COE members actively monitor and manage the discussion channel to ensure questions are answered quickly and correctly.

The help desk is fully prepared to handle all known and expected Power BI technical support issues, and the COE provides appropriate extended support when required.
400: Capable A recognition program is established, and it generates enthusiasm and encourages sharing best practices.

SLAs are in place to define help desk support expectations, including extended support, and they are clear to everyone involved.
500: Efficient Bidirectional feedback loops exist between the help desk and the COE.

Key performance indicators measure community engagement and satisfaction.

Automation is in place when it adds direct value to the user experience (for example, automatic access to the community), or for specific help desk activities (for example, use of APIs and scripts that increase speed and reduce error).

Next steps

In the next article in the Power BI adoption roadmap series, learn about system oversight and administration activities.