Home » Articles
Articles
- Using Power BI to Report on Location Columns in SharePoint
At the end of 2018, SharePoint received something that we haven’t seen for a long time – a new column type, Location. Location columns will look up an address and geocode it as it is being entered in a form. It will also separate all the constituent parts of the address ... read more - Get the most out of Power Query in Power BI Dataflows
Power BI dataflows are the first place that many users will encounter the new Power Query web based interface. Until now Power Query has been restricted to Power BI Desktop and Excel. This new web interface is, well, new, and it doesn’t contain all of the capabilities of the ... read more - Use Power BI dataflows to warehouse SharePoint list data
Reporting on SharePoint data has been a requirement for a long time, and there have been many approaches to fulfill this need. Custom web parts, Data View web parts and SSRS direct connected reports have historically been some of the solutions, but they all suffer from the same problem. ... read more - Business Intelligence in SharePoint 2019
The recent availability of the SharePoint 2019 public preview, and the supporting information that accompanies it has clarified the status of Business Intelligence features in SharePoint 2019. This release, with one exception, is the culmination of the process of decoupling BI from SharePoint which began in SharePoint 2016 through the ... read more - Using Excel Files with Power BI Desktop and SharePoint
As discussed in a previous post, Working with Excel Files in the Power BI Service, Excel and Power BI have a rich, complex relationship. Power BI Desktop is the primary design tool for Power BI, and it has many feature overlaps with Excel as an analytic tool. Excel can be ... read more - Working with Excel files in the Power BI Service
Power BI has been able to work with Excel files since it was first introduced. Indeed, it was born from the analytic capabilities in Excel. Users can connect directly to Excel files by using the Power BI service and nothing but a browser. However, depending on the content of the ... read more - Using Power BI to Report on Lookup Fields in SharePoint
This post is the sixth and final post in a series exploring Power BI and complex data types in SharePoint. This post examines the various options in Power BI for working with lookup fields. The previous posts are: Using Power BI to Report on Multi-Value SharePoint Fields Using Power BI ... read more - Using Power BI to Report on Hyperlink or Picture Fields in SharePoint
This post is the fifth in a series exploring Power BI and complex data types in SharePoint. This one details the use of SharePoint Hyperlink or Picture fields. The previous posts are: Using Power BI to Report on Multi-Value SharePoint Fields Using Power BI to Report on Person Fields in ... read more - Using Power BI to Report on Rich Text Data Fields in SharePoint
This post is the fourth in a series exploring Power BI and complex data types in SharePoint. It discusses working with using Power BI to report on rich text fields from SharePoint. The previous posts are: Using Power BI to Report on Multi-Value SharePoint Fields Using Power BI to Report ... read more - Using Power BI to Report on Managed Metadata Fields in SharePoint
This post is the third in a series exploring Power BI and complex data types in SharePoint. The first post explores working with multi-value columns, and the second post covers working with person fields. In this one, we’ll explore some of the nuances of working with managed metadata fields Managed ... read more - The Road Ahead for SQL Server Reporting Services and Power BI Report Server
Power BI has garnered a lot of attention in the past few years as the “place to be” for Microsoft business intelligence. Power BI is of course Microsoft’s cloud platform for dashboarding and reporting. On premises, Microsoft’s reporting platform has traditionally been SQL Server Reporting Services (SSRS) and is ... read more - Using Power BI to Report on Person Fields in SharePoint
This post is the second in a series exploring Power BI and complex data types in SharePoint. The first post explores working with multi-value columns. In this one, we’ll explore some of the nuances of working with person fields Person fields in SharePoint are just a special case of the ... read more - Using Power BI to Report on Multi-Value SharePoint Fields
Power BI has direct support for reporting on SharePoint lists and documents whether SharePoint is on-premises or in the cloud. Getting at your data is relatively straightforward if you know the URL, but as I’ve written about before, SharePoint data can be idiosyncratic. Text and number fields work right away, ... read more - Using Power BI for Facebook Location Tracking
Three years ago I wrote an article about how to map your Facebook check in in Excel using Power Query and Power View. Given that Power View has gone the way of the Dodo for all intents and purposes, I have been meaning to rewrite it using Power BI to ... read more - Get Power BI Desktop from the Microsoft Store
If you’re a Power BI Desktop user, you are likely familiar with the monthly update cadence. Once per month, a new Power BI Desktop is released, and normally it contains at least one new feature that you WILL want to use. In case you miss it, a little indicator will ... read more