• Failed to register the gateway key

    We have seen a few cases some in where we get an error like the following Failed to register the gateway key. Before trying to register the gateway key again, confirm that the Data Management Gateway is in a connected state and the Data management Gateway...
  • Power BI Designer Preview

    NOTE: This is preview material and is subject to change. Information listed here is good as of 12/19/2014. The Power BI Designer is a new companion application for Power BI. It is a standalone Windows Desktop application that can be downloaded from the...
  • Data Sources via Power BI

    NOTE: Information in this post is valid as of 12/18/2014 and is subject to change in the future. Data Sources within Power BI are used to define an on-premise data source within the Admin Center. Data Sources rely on a defined Gateway . You can have multiple...
  • Data Management Gateway Introduction

    NOTE: Information in this post is valid as of 12/17/2014 and is subject to change in the future. The Data Management Gateway is needed to connect your on premise servers with Power BI in the cloud. If you want to refresh your data in the cloud with data...
  • Overview of O365 Admin

    NOTE: Information in this post is valid as of 12/10/2014! Information is subject to change in the future. This is to provide a general overview of the O365 Admin Portal for folks that are using Power BI and may not be familiar with the O365 aspects of...
  • Power Query: Unable to import Non-English SharePoint Lists

    Within Power Query, you may want to pull data from a SharePoint List that is hosted on SharePoint Online. When loading from the site, you will see the lists populated in the Navigator pane. This is what it looks like for my current site that is set to...
  • Silverlight may be blocked by recent IE Update affected Power View

    Internet Explorer has released an update in November’s patches that will block old versions of Silverlight. November 2014 updates for Internet Explorer http://blogs.msdn.com/b/ie/archive/2014/11/11/november-2014-updates-for-internet-explorer.aspx You...
  • Power BI and O365 Developer

    One of the ways you can use Power BI is to add it to an existing subscription that you have for O365. Some people may have the O365 Developer Pack. This revolves around a developer site to work with while you are creating projects or solutions. Sign up...
  • Power BI Admin: No Power BI for Office 365 License

    There are two issues I’ve seen crop up with Power BI Admin Center. I talked about one of them a while ago regarding the “ You are not authorized ” error. I’ll talk about the other here. This is more just some confusion about how it works and how it is...
  • Power Query Sign in, Certificates and Troubleshooting

    I worked on a Power Query Sign in issue recently that took a different spin from what I would have expected. Through the course of troubleshooting that issue, I actually learned a bit about how the sign in process works with Power Query, so I thought...
  • Back to the Future with Power Query – Invalid Object name

    I got pulled into an interest case this week that brought back some fond memories. The customer was trying to use Power Query to connect to SQL Server, but was getting errors. It was indicated that pulling in data via Power Pivot or the Excel Data Tab...
  • Power BI Sites vs. My Power BI

    I have gotten some questions regarding the Power BI Sites and usage of them. There are two different aspects to Power BI, and I wanted to go through them to help folks understand their usage. Power BI Sites The Power BI Site is attached to a given SharePoint...
  • Failed to find a match for the data source

    I’ve seen this following scenario come across a few times. When trying to run a Scheduled Data Refresh, you may see an error similar to the following: “Refreshing the data failed” Within the Power BI Admin Center, if you go to System Health, you will...
  • Why is my background not showing in the Power BI Windows App?

    There was a customer comment regarding the fact that the background of their Power View report wasn’t showing up when viewing the report in the Power BI App from the Windows Store. NOTE: This information is true as of April 2014. The reason for this is...
  • OData Feed through Excel or Power Pivot vs. Power Query

    We had a customer that was trying to pull data into Excel by way of an OData feed. This actually related to a Project Server hosted in a SharePoint 2013 On Premise deployment. Within Excel, we have multiple ways to import data. This could be through the...
  • Thumbnail Images within Power BI Sites

    We’ve had some questions regarding the thumbnail images within the Power BI Sites about what the different images mean. I wanted to go through these to provide some understanding, along with how you can control some of the behavior. Not Enabled Workbooks...
  • Power BI Licensing

    We have been seeing a lot of cases that surround Licensing. Either regarding what is available, or how do I apply licenses. My goal for this blog post is to try and help clear up that confusion. NOTE: This information is valid as of this posting date...
  • Not Authorized to access Power BI Admin Center

    We had a customer that had created an O365 Tenant with the Power BI License. Then they added a custom domain to their Tenant and added new logons for the custom domain. After that, they removed the original logons with the onmicrosoft.com domain. They...
  • What URL do I use for the Power BI App?

    When using the Power BI App for Windows, in order to get to your reports, you have to start with a URL to pull the reports (Workbooks) from. This is done by going to the browser area, and then you can enter the URL after swiping up from the bottom or...
  • Power Query Navigator not showing the correct number of items

    I ran into an interesting issue where the customer indicated that they were not seeing the correct number of items for a Database that had a large number of tables, however Power Pivot and the Excel Data Tab were showing the items. To illustrate this...
  • Working with Data Models created using SQL Server 2008 R2 PowerPivot for Office Excel 2010 in Power BI

    Guest Post by Kay Unkroth Power BI supports PowerPivot data models of any version. Users can choose between SQL Server 2008 R2 and SQL Server 2012 PowerPivot for Excel 2010 or simply use the latest PowerPivot version directly integrated with Excel 2013...
  • Unable to view a Power View reports in SharePoint Online

    We have seen a few instances of customers not able to view their Power View reports. While Power View is part of Power BI, the ability to view Power View reports within Silverlight has actually been available in SharePoint Online for some time. When you...
  • Connectivity 101

    There are different ways to get data into Excel for use with Power BI. You can also get data from a bunch of different sources. You can use Excel Data Import, Power Query and Power Pivot to pull data in. Sometimes, you may receive errors when trying to...
  • Welcome to the Power BI Support Blog!

    Welcome to the Power BI Support Blog! This blog will contain posts from the support technicians that work cases related to Power BI. These engineers come from different teams including SQL, Office and SharePoint support with a wide range of experience...