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…
» Les merInternet 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…
» Les merThere 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…
» Les merI 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…
» Les merI 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…
» Les merI’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…
» Les merI 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…
» Les merThere 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…
» Les merWe 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…
» Les merWe’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…
» Les mer