Archives – The White Pages

Expand All

June 2021 (1)
- 01: First impressions of the new “Visualize in Power BI” feature for SharePoint Lists (0)
April 2021 (1)
- 28: Using Power BI with Microsoft Lists (0)
March 2021 (1)
- 08: It’s time to stop using Power Pivot (3)
February 2021 (1)
- 19: Using Power BI Incremental Refresh with Azure Data Explorer (0)
November 2020 (2)
- 30: Automatically move your Application Insights data into Azure Data Explorer (2)
- 02: Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI (1)
October 2020 (1)
- 26: Dynamic time zone conversion using Power BI (4)
September 2020 (2)
- 23: Introducing the new Power BI Premium “Gen-2” Architecture (0)
- 22: Power BI Announces Premium-per-User licensing (0)
June 2020 (2)
- 24: Connect to Application Insights and Log Analytics with Direct Query in Power BI (27)
- 09: Creating Data Driven Subscriptions for Power BI Reports (0)
May 2020 (2)
- 06: Working with Time Zones in the Power BI Relative Time Slicer and Filter (1)
- 06: Formatting the X Axis in Power BI Charts for Date and Time (5)
March 2020 (1)
- 31: Increase your OneDrive Storage Limit beyond 5 TB (5)
November 2019 (1)
- 12: A low cost approach for paginated report subscriptions in Power BI (3)
October 2019 (2)
- 18: Keep your Power BI SharePoint reports current with Microsoft Flow (3)
- 11: Fixing Power BI Report Builder Connection Errors (2)
June 2019 (2)
- 07: Connecting Power BI workspaces and SharePoint sites (1)
- 04: Connect to Power BI dataflows and datasets using Power BI Desktop with multiple accounts (1)
May 2019 (2)
- 29: Creating complex real-time dashboards with Power BI (3)
- 07: Using Microsoft Graph Data Connect with Power BI Dataflows (2)
January 2019 (1)
- 15: Using Power BI to Report on Location Columns in SharePoint (1)
November 2018 (2)
- 16: Get the most out of Power Query in Power BI Dataflows (4)
- 15: Use Power BI dataflows to warehouse SharePoint list data (3)
August 2018 (1)
- 02: Business Intelligence in SharePoint 2019 (5)
July 2018 (2)
- 31: Using Excel Files with Power BI Desktop and SharePoint (4)
- 20: Working with Excel files in the Power BI Service (5)
April 2018 (4)
- 18: Using Power BI to Report on Lookup Fields in SharePoint (5)
- 12: Using Power BI to Report on Hyperlink or Picture Fields in SharePoint (3)
- 10: Using Power BI to Report on Rich Text Data Fields in SharePoint (22)
- 09: Using Power BI to Report on Managed Metadata Fields in SharePoint (3)
March 2018 (1)
- 20: The Road Ahead for SQL Server Reporting Services and Power BI Report Server (3)
January 2018 (2)
- 30: Using Power BI to Report on Person Fields in SharePoint (20)
- 24: Using Power BI to Report on Multi-Value SharePoint Fields (17)
November 2017 (1)
- 29: Using Power BI for Facebook Location Tracking (2)
October 2017 (1)
- 12: Get Power BI Desktop from the Microsoft Store (5)
September 2017 (5)
- 29: OneDrive is Ready – It’s Seriously Time to Ditch the X: Drive (2)
- 26: Understanding the Power BI Capacity Based SKUs (27)
- 22: SharePoint and the New SSRS/PBIRS Native Mode Report Viewer Web Part (10)
- 18: SQL Server Reporting Services vs Power BI Report Server – What’s the Difference? (15)
- 17: Which Premium SKU is Needed to embed Power BI Reports in SharePoint and Microsoft Teams (8)
August 2017 (4)
- 26: Power BI Report Server Completes the Vision for On-Premises Reporting (2)
- 23: Power BI Embedded is not for Embedding Power BI Reports (5)
- 21: What License is Needed to Use the Power BI Web Part? (8)
- 18: Power BI Time Values in the Browser are Different Than Those in the Desktop (4)
June 2017 (1)
- 14: Turkish Airlines Fail – A Case Study in Terrible Customer Service (3)
May 2017 (1)
- 15: The Power BI Premium Pricing Model – The Good, The Bad and the Ugly (17)
April 2017 (1)
- 13: Use Power BI to Help Manage Your SharePoint Sites (2)
February 2017 (1)
- 24: The Difference Between Reporting and Analytics is 42 (3)
January 2017 (5)
- 27: Enabling the new OneDrive Sync Client for SharePoint (6)
- 24: OneDrive and SharePoint – Together Again (2)
- 20: Analyzing Your WordPress Site with Power BI and Google Analytics (6)
- 17: So, You Can Disable Office 365 Groups After All (7)
- 16: You Can’t Disable Office 365 Groups (6)
December 2016 (1)
- 05: Understanding Office 365 Groups (9)
November 2016 (4)
- 18: Completing the Microsoft Reporting Roadmap (0)
- 18: The Future of Report Integration with SharePoint (3)
- 10: With Microsoft Teams, Office 365 Groups Can Now Have Multiple Planner Plans (2)
- 02: Microsoft Teams and the New Microsoft Social Landscape (7)
October 2016 (1)
- 25: How to Migrate a WordPress site to Azure Using In-App MySQL (8)
September 2016 (2)
- 30: SharePoint and Power BI – Better Together (15)
- 28: Microsoft Re-Adopts Yammer as a first class citizen (0)
July 2016 (1)
- 06: A Simplified Method of Working with SharePoint Data in Power BI (11)
May 2016 (5)
- 17: How to Enable Unlimited Storage in OneDrive for Business (7)
- 06: SQL Server 2016–Which Edition Do You Need for Business Intelligence? (6)
- 04: The State of Analytics in SharePoint and Office 365 (2)
- 04: SharePoint 2016 Team SItes and Groups – It All Comes Together (2)
- 02: Integrating Microsoft Flow with Power BI for Real Time Reporting (0)
April 2016 (2)
- 08: Power BI Analyze in Excel – The beginning of a beautiful thing? (7)
- 04: Analyze in Excel – Setup and initial issues (5)
March 2016 (8)
- 28: SSRS 2016 – Integrated or Native Mode – Which one should you use? (14)
- 25: Where we are with the BI Workload in SharePoint 2016 – BI Focal #4 (0)
- 14: What you need for Business Intelligence in SharePoint 2016 (5)
- 11: Integrating SharePoint 2016 with SSRS Native Mode (17)
- 09: Configuring SSRS 2016 Integrated Mode with SharePoint 2016 (36)
- 08: Using PowerPivot for SharePoint with SharePoint 2016 (6)
- 03: Enable PowerPivot Support in Office Online Server 2016 and Sharepoint 2016 (5)
- 03: Connecting Excel to Data with SharePoint 2016 and Office Online Server 2016 (12)
February 2016 (2)
- 23: Power BI Enterprise Gateway and SSAS – What Account Should You Use? (3)
- 15: Power BI and Shark Attacks – Oh My! (5)
January 2016 (1)
- 05: Adding Excel Services Capabilities to a SharePoint 2016 Farm (28)
December 2015 (3)
- 14: Rethinking Business Intelligence in SharePoint and SQL Server 2016 (6)
- 02: How to Enable Cortana and Quick Insights with Power BI (2)
- 01: OneDrive, TwoDrive, ThreeDrive (12)
November 2015 (2)
- 07: Diving with Sway (or What I Did on my Autumn Vacation) (0)
- 04: The Last Days of PerformancePoint (0)
September 2015 (2)
- 26: What’s Happening to Excel Services in SharePoint 2016 (10)
- 03: How to Set an Hourly Refresh Schedule with Power BI (2)
August 2015 (1)
- 11: Working with Excel Files in Power BI V2 (1)
July 2015 (4)
- 29: Where Did Power View Go in Excel 2016? (31)
- 24: Connecting to Analysis Services in Power BI (0)
- 23: Sharing Power BI Content with Office 365 Groups (5)
- 14: The New Power BI Personal Gateway – Do I Need It? (8)
June 2015 (1)
- 24: Analysis Services Power Pivot Mode in SQL Server 2016 (1)
May 2015 (4)
- 30: Using Excel With External Data – What’s the Right Tool? (21)
- 25: Power BI Licencing Demystified (2)
- 12: Ignite 2015 Impressions (4)
- 11: PerformancePoint Lives! (4)
April 2015 (1)
- 16: SQL Server Data Tools, BIDS, Visual Studio – What Do You Need? (24)
March 2015 (2)
- 27: License Requirements for SQL Server Reporting Services in SharePoint Integrated Mode (6)
- 24: Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint (3)
February 2015 (1)
- 02: Something Went Wrong When Connecting Power BI to SSAS (2)
January 2015 (3)
- 28: The New Power BI – Now With Enterprise! (6)
- 27: Power BI Data Management Gateway 1.4 – Where is it heading? (1)
- 16: Calculate a Due Date Based on Business Hours With Nintex Workflow (16)
December 2014 (5)
- 18: This Column Name is not What You Think – Be Careful With Column Names in SharePoint 2013 / Office 365 (12)
- 15: Check-In Tracking with Power Query and Power View (1)
- 11: Limitations for Power Query OData Feeds in Power BI (5)
- 10: Reporting Services Web Part Error After SharePoint Upgrade (3)
- 10: Error 1603 Installing Reporting Services Add-In onto a New SharePoint Server (6)
November 2014 (1)
- 07: Power BI as a Product Today (3)
October 2014 (1)
- 07: How to Use a Wildcard Certificate With Office Web Apps 2013 (14)
September 2014 (2)
- 24: Using Power Query with SharePoint Lists and Lookup Fields (17)
- 16: Reporting Services Web Part Won’t Save Parameters with SharePoint 2013 SP1 (0)
August 2014 (2)
- 26: Power BI Data Management Gateway 1.2 Changes the Game (7)
- 26: Incorrect URL When Using a Multilingual SharePoint Blog Site (3)
July 2014 (1)
- 20: Problems Installing PowerPivot for SharePoint and Reporting Services From SQL Server 2012 SP2 on SharePoint 2013 (3)
May 2014 (2)
- 06: Changes to Data Loading Features in Power Query – May 2014 (1)
- 06: Set Your Data Load Defaults in Power Query (1)
April 2014 (1)
- 25: How to Connect to PowerPivot Workbooks With PerformancePoint (2)
March 2014 (6)
- 30: Using the SSIS OData Source Connector With SharePoint Online Authentication (89)
- 29: How to Change the Language for a SharePoint Site (0)
- 25: Don’t Update Your Power Query After Building a Model (5)
- 14: Changes to the Default Data Loading Options in Power Query (1)
- 13: How to Refresh Data Models in Office 365 from On Premises Using Nintex Workflow – A Hybrid Approach (1)
- 09: Business Intelligence in SharePoint and Office 365 (0)
February 2014 (2)
- 05: Problems Manually Refreshing Power BI Enabled Workbooks (2)
- 05: Scheduled Data Refresh in Power BI (11)
January 2014 (2)
- 23: Using Multiple WordPress Blogs with Azure Web Sites (6)
- 08: Append Multiple Tables in Power Query (9)
December 2013 (3)
- 11: Delete a Shared Power Query in Power BI (0)
- 03: Power Pivot Updates to Excel 2013 – November 2013 (0)
- 02: Whither Power Pivot for SharePoint? A Comparison With Power BI (3)
November 2013 (5)
- 19: Changes to the Power BI Data Management Gateway – Nov 2013 (0)
- 18: New Clarity on SharePoint and Office Release Cadence (0)
- 13: Conditionally Starting a Workflow with the Nintex Workflow Filter Action (2)
- 11: Changes to Data Loading in the November 2013 Power Query Update (4)
- 03: Running a Business in the Cloud – 3 Years In (2)
October 2013 (2)
- 10: Installing Office 365 App : Sorry, there was something wrong with the download (3)
- 03: Analyzing Data with Power BI from Beginning to End (6)
September 2013 (8)
- 30: Software Boundaries and Limits for Power BI (0)
- 24: Power BI – Working With the Data Management Gateway (16)
- 22: Update Your Power BI On Premises Data Management Gateway (0)
- 13: How to Hide Objects From the Power BI Mobile Apps (1)
- 12: Query Limit with Power BI On Premises Data Management Gateway (0)
- 10: Enable LastPass and other Add-Ins in Windows 8.1 (4)
- 06: How To Load Data Directly Into the Excel (Power Pivot) Data Model (5)
- 04: Power Query Preview vs Power Query Release – How Can I Share a Query? (3)
August 2013 (1)
- 30: Working With Power BI, Office 365 and File Size Limits (8)
July 2013 (4)
- 29: Power Pivot and Power View Demonstration – Profit Analysis for Great Plains (0)
- 22: Power Query Navigator Can Only View 2,000 Items, and Other Limits (2)
- 18: Power BI – What Is It, And Why Does It Matter? (8)
- 06: How to display Specific Content to Anonymous or Authenticated Users in SharePoint (1)
March 2013 (1)
- 26: How to display Specific Content to Anonymous or Authenticated Users in SharePoint (1)
December 2012 (1)
- 11: Configure Your SharePoint Farm for Business Intelligence (0)
October 2012 (1)
- 05: Setting Up Reporting Services and PowerPivot With SharePoint (1)
September 2012 (3)
- 10: Troubleshooting and Removing a Failed Installation or Upgrade of PowerPivot for SharePoint (17)
- 07: Installing and/or Upgrading a Multi-Server SQL Server Reporting Services 2012 SharePoint Mode Farm (1)
- 03: Using Per-User Identity with Reporting Services and SharePoint (8)
August 2012 (1)
- 07: How To Configure the Nintex Workflow Preview on Office 365 (1)
July 2012 (4)
- 23: Office Web Applications In SharePoint 2013 – Bigger, Faster, Better? (0)
- 20: Setting Up Reporting Services 2012 With SharePoint 2013 (33)
- 17: Using the new Excel 2013 Data Model with SharePoint (3)
- 17: Profile Import in SharePoint 2013 – Back to the Future (18)
June 2012 (2)
- 22: Quick PowerPivot/PowerView Demonstration on SharePoint Shop Talk (0)
- 21: The Health Analyzer and PowerPivot for SharePoint (12)
May 2012 (1)
- 15: Best Practices for Using Reporting Services With SharePoint (0)
April 2012 (3)
- 26: Migrate Reporting Services from Native Mode To SharePoint Integrated Mode (2)
- 17: Fixing Access Errors When Creating a BISM Connection for PowerView (4)
- 15: How To Automate SharePoint Report Creation With SSIS and SSRS (8)
March 2012 (3)
- 23: How To Get A Comprehensive List of all E-Mail Enabled Libraries in SharePoint (6)
- 18: Upgrading SQL Server Reporting Services to 2012 In SharePoint Integrated Mode (18)
- 14: How To Upgrade SQL Server 2012 RC0 to Release (RTW or RTM) (0)
February 2012 (4)
- 10: Using SharePoint Filters with Reporting Services Parameters for Personalized Reports (2)
- 09: TechNet Radio Community Corner Interview (0)
- 07: Using SQL Server Report Builder with Internet Explorer 9 (2)
- 01: Upcoming Speaking Engagements – Spring 2012 (0)
January 2012 (1)
- 18: Playa Del Carmen – Dive Report (1)
December 2011 (3)
- 19: Upgrading and Moving Integrated Mode Reporting Services With SharePoint (0)
- 12: Lync For Windows Phone 7: Unable to sign in. Can’t connect to the server (0)
- 09: How To Fix Broken Reporting Services Content Type Names (0)
November 2011 (2)
- 14: Reporting Services Reports With Sparklines Running Very Slow (2)
- 04: File Formats for the SQL Server 2012 (Denali) Reporting Services Web Services Renderer (9)
October 2011 (7)
- 28: How to Get SharePoint Data Into a Data Warehouse (And Back Again) (2)
- 21: Why I Love Office 365 (0)
- 13: SharePoint Online Fall 2011 Service Update Starts Oct 20 (2)
- 10: How to Batch Download Videos and Presentations from SharePoint Conference 2011 (6)
- 10: SharePoint Tools for Windows Azure, Visual Studio, jQuery, and HTML5 (1)
- 08: SharePoint Conference 2011– That’s A Wrap (4)
- 08: SharePoint Conference 2012 Announced (0)
September 2011 (4)
- 27: Archiving Your SharePoint Workflow History Lists (9)
- 21: Upgrading From WSS 3.0 to Search Server Express (0)
- 16: SharePoint 2010 Upgrade breaks Microsoft Access Client Application (1)
- 07: How To Replace A Custom Field In SharePoint 2010 (2)
August 2011 (3)
- 31: Upgrade Failure – The statistics ‘xxxx’ is dependent on column ‘tp_ContentType’ (2)
- 31: SharePoint Upgrade Failure – Orphaned Documents not Orphaned Lists (2)
- 10: Strong Passwords Are A Bad Idea (0)
July 2011 (1)
- 05: SharePoint 2010 Service Pack 1, the June 2011 CU, and What to Install (0)
June 2011 (3)
- 28: Election Night Application Featured on MSDN (0)
- 28: How to Add the SRV Records for Office 365 to a DNS Provider (26)
- 24: Using Nintex Workflow and SharePoint to Create InfoPath Forms on a Schedule (4)
May 2011 (4)
- 23: How to Manually Migrate from BPOS to Office 365 (4)
- 17: Access Denied When Accessing Search Service Application With Search Server Express 2010 (2)
- 17: Announcing the Premiere of The Data Queen (0)
- 02: Election Mapping In The Cloud With Silverlight and Azure (0)
April 2011 (1)
- 15: Search Results Not Showing For Anonymous Users in A SharePoint Publishing Site (2)
March 2011 (7)
- 24: Talk Technet Episode 13 Now Available (0)
- 23: Building an Automatic XML Sitemap Generator for your SharePoint Site (4)
- 21: Using Silverlight and the SharePoint Client Object Model With Anonymous Access (2)
- 10: Talk TechNet Episode 13: SharePoint (0)
- 09: SharePoint Conference 2011 Registration is Now Open (0)
- 03: Second Foundation Intelligence is now UnlimitedViz (0)
- 01: Wakatobi Dive Resort, As Good As It Gets (0)
February 2011 (2)
- 08: Using Document Templates with Lists and Content Types in SharePoint (22)
- 01: SharePoint Loses Access to Central Admin Content Database (0)
January 2011 (7)
- 28: Setting up WordPress on Windows and SQL Azure: A Walkthrough (13)
- 24: The White Pages are now Running on Windows and SQL Azure (0)
- 19: Using XSL to get the URL of the Current SharePoint Page for the Content Query Web Part (1)
- 18: Windows Live Photo Gallery and Digital Frames–A Match Made In Heaven (0)
- 18: Joining a Machine to A Domain over VPN with Windows 7 (3)
- 12: Nice to be Away, and Good to be Back (0)
- 01: MVP Award, A Happy New Year Indeed (2)
December 2010 (4)
- 10: A Conversation in the Cloud (0)
- 08: Why the Office is a Bad Place for Work (0)
- 06: Connecting to Cubes and External Data with Excel in SharePoint (21)
- 02: UNC Path Naming for files stored on SharePoint (24)
November 2010 (4)
- 30: The Cloud Computing Landscape (0)
- 30: Bye Bye Blackberry (3)
- 11: How to Replace the Built in SharePoint Approval Workflow (1)
- 04: Performance Point Dashboard Designer Won’t Launch for a New Installation (13)
October 2010 (5)
- 28: Second Foundation Intelligence named as a finalist for the Business Intelligence Solution of the Year in the 2010 Microsoft IMPACT Awards (0)
- 19: BPOS is now Office 365 (0)
- 16: How to Build a Site Collection Template from A Web Template in SharePoint 2010 (31)
- 07: Integrating SharePoint On Premises With BPOS and Exchange Online: Part 2 – Inbound (16)
- 05: Adding PDF Icon or Creating a Site From Template triggers Prompt for Download In SharePoint 2010 (20)
September 2010 (6)
- 23: Secure Store Service is Included With Search Server Express 2010 (2)
- 23: How to Index PDF Files with SharePoint Foundation 2010 (6)
- 22: Office Web Applications Installation Issues–Be VERY Careful (4)
- 21: Integrating SharePoint On Premises With BPOS and Exchange Online: Part 1–Outbound (13)
- 13: Best Error Message Ever (0)
- 10: Configuring and Branding a Visual Web Part Solution for SharePoint 2010 With Visual Studio 2010 (1)
August 2010 (7)
- 30: Feeding the ducks (1)
- 26: Connection Limitations using BCS With SharePoint Foundation and a Workaround (3)
- 23: Reporting Services Error After Creating a SharePoint Site (2)
- 16: SQL Express, Microsoft Internal Database, and SharePoint – Be Careful Upgrading (3)
- 09: Henley2010Finish.MOV (0)
- 07: License State Error Joining a SharePoint 2010 Server to an Existing Farm (0)
- 06: What Domain Accounts to Use For SharePoint 2010 (0)
July 2010 (5)
- 23: Windows Live Essentials “Wave 4” And Windows Phone 7 – Why You Should Care (1)
- 13: WPC Day 1 (0)
- 08: Who Are The SharePoint Sample People? (1)
- 07: I’ll Be At the Microsoft World Partner Conference Next Week (0)
- 05: Using a Fixed Width Page in SharePoint 2010 (6)
June 2010 (8)
- 29: Moving To Cloud Based Email–My BPOS Story (0)
- 23: Overriding SharePoint 2010 CSS Classes – Background Images (9)
- 23: SharePoint 2010 Page Layouts – What’s this UIVersionedContent all about? (2)
- 21: Storing Data In The Cloud (0)
- 10: Now THAT’S Planning Ahead – Next SharePoint Conference Announced (0)
- 08: Exporting a Publishing site from SharePoint 2010 Enterprise and Importing Into Standard (3)
- 08: Editing Page Layouts in SharePoint Designer 2010 – Edit in Advanced Mode (7)
- 06: Flight of the Honeybee (1)
May 2010 (10)
- 29: spSecurityTrimmedControl – An Indispensible Tool for your public facing SharePoint web site (and others) (3)
- 25: Garden Life (1)
- 19: Deploying Reporting Services Reports to SharePoint using Business Intelligence Development (Visual) Studio (5)
- 18: Using Themes and CSS with SharePoint 2010 (8)
- 14: Opening PDF Files in SharePoint 2010 (18)
- 06: Format an HTML Safe String using .NET (0)
- 06: Installation Considerations for Reporting Services in SharePoint Integrated Mode (5)
- 04: How to Completely Remove All Traces of Office 2010 From Your System (142)
- 03: Truly Great Software – JRiver Media Center (0)
- 02: Configuring Profile Import in SharePoint 2010 – A Way Around the Minefields (11)
April 2010 (12)
- 30: Enabling Meaningful Errors in SharePoint 2010 (0)
- 30: Confusion When Upgrading from SharePoint 2007 to SharePoint 2010 In Place (0)
- 29: Diving Pictures from Grand Turk – Nov 2008 (0)
- 28: Required SQL Server Versions and Patch Levels for SharePoint 2010 (0)
- 26: How to get SharePoint Designer 2010 and a few gotchas (0)
- 24: Cabo Pulmo 2009 Dive Pictures (0)
- 23: Not Supported Error While Doing A Clean Install of SharePoint 2010 RTM (0)
- 23: Observations from AIIM SharePoint Summit (1)
- 19: Cuba Diving (0)
- 17: Mapping in SQL Server 2008 R2 Reporting Services (1)
- 16: Back to VMWare Workstation (2)
- 16: That’s A-Moray (0)
October 2009 (1)
- 09: Changing the name of the Title Field in SharePoint (1)
September 2009 (3)
- 10: XP Mode and Sharing Documents (0)
- 09: Installing SharePoint 2007 on Windows 2008 R2 (0)
- 08: Using Windows 7 XP Mode with Cisco VPN (0)
August 2009 (1)
- 26: Warning Messages when Upgrading to Windows Server 2008 R2 (0)

One Comment

Michael B. Nielsen

Hi John

I enjoy your articles as well as your session on Ecsp18 🙂

Maybe you have som hints on the following issue:

I am a SharePoint Guy with a task for our internal Power BI Guy.

I have about 200 SPOnline sites(webs) with a set of documents on each site. I need a consolidated report on the documents status from all sites. The document libary columns are simple no lookup columns etc.

My power BI guys claims he is facing performance issues/ timeouts when retrieving data from more than a few webs.

Any hints/best practices to pursuit on this topic ?

/ Michael

June 21, 2019

This site uses Akismet to reduce spam. Learn how your comment data is processed.