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…
» Read moreInternet 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…
» Read moreThere 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…
» Read moreI 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…
» Read moreI 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…
» Read moreI’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…
» Read moreI 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…
» Read moreThere 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…
» Read moreWe 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…
» Read moreWe’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…
» Read more