Home » Articles
Articles
- 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 - OneDrive is Ready – It’s Seriously Time to Ditch the X: Drive
If you are in information worker of any sort, and have been at it for any more than a couple of years, you’ve experienced it – the X: drive. Or the S: drive, P, R, whatever the letter. It’s the drive letter that is mapped to a network based file ... read more - Understanding the Power BI Capacity Based SKUs
Power BI licensing has changed again. This week at Microsoft Ignite, Microsoft introduced a new capacity based SKU for Power BI Embedded, intended for ISVs and developers: The A SKU. This brings the number of capacity based SKUs to 3, with each category having numerous sub categories. This means that ... read more - SharePoint and the New SSRS/PBIRS Native Mode Report Viewer Web Part
When SQL Server 2016 was released, I wrote a post that covered how to integrate SharePoint 2016 with SQL Server Reporting Services (SSRS) in native mode. I wrote that post because although SSRS was still available in SharePoint Integrated Mode, many of the new features were only in Native ... read more - SQL Server Reporting Services vs Power BI Report Server – What’s the Difference?Power BI Report Server (PBIRS) was first introduced in May 2017. Based on SQL Server Reporting Services (SSRS), it brings the ability to work with Power BI reports completely on premises in addition to all the other capabilities of SSRS. Given this, it would be reasonable to conclude that PBIRS ... read more
- Which Premium SKU is Needed to embed Power BI Reports in SharePoint and Microsoft Teams
A short time ago, I posted an article explaining the difference between a Power BI Pro license, and Power BI Premium capacity, and the fact that you’ll at least need one or the other in order to share a Power BI report on a SharePoint page via the Power BI ... read more - Power BI Report Server Completes the Vision for On-Premises Reporting
Microsoft today made available the August 2017 preview of Power BI ReportServer 2017. This preview includes the long awaited support of embedded data models, as well as the ability to render Excel reports natively. This is a major step forward, because with this release, Microsoft has completed its vision for ... read more
