Expand All
- November 2020 (2)
- October 2020 (1)
- September 2020 (2)
- June 2020 (2)
- May 2020 (2)
- March 2020 (1)
- November 2019 (1)
- October 2019 (2)
- June 2019 (2)
- May 2019 (2)
- January 2019 (1)
- November 2018 (2)
- August 2018 (1)
- July 2018 (2)
- April 2018 (4)
- March 2018 (1)
- January 2018 (2)
- November 2017 (1)
- October 2017 (1)
- 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 (26)
- 22: SharePoint and the New SSRS/PBIRS Native Mode Report Viewer Web Part (9)
- 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)
- June 2017 (1)
- May 2017 (1)
- April 2017 (1)
- February 2017 (1)
- January 2017 (5)
- December 2016 (1)
- 05: Understanding Office 365 Groups (9)
- November 2016 (4)
- October 2016 (1)
- September 2016 (2)
- July 2016 (1)
- 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)
- 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 (11)
- February 2016 (2)
- January 2016 (1)
- December 2015 (3)
- November 2015 (2)
- September 2015 (2)
- August 2015 (1)
- July 2015 (4)
- June 2015 (1)
- May 2015 (4)
- 30: Using Excel With External Data – What’s the Right Tool? (19)
- 25: Power BI Licencing Demystified (2)
- 12: Ignite 2015 Impressions (4)
- 11: PerformancePoint Lives! (4)
- April 2015 (1)
- March 2015 (2)
- February 2015 (1)
- January 2015 (3)
- 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)
- September 2014 (2)
- August 2014 (2)
- July 2014 (1)
- May 2014 (2)
- April 2014 (1)
- March 2014 (6)
- 30: Using the SSIS OData Source Connector With SharePoint Online Authentication (88)
- 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)
- January 2014 (2)
- December 2013 (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)
- 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)
- 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)
- December 2012 (1)
- October 2012 (1)
- September 2012 (3)
- August 2012 (1)
- July 2012 (4)
- June 2012 (2)
- May 2012 (1)
- April 2012 (3)
- March 2012 (3)
- February 2012 (4)
- January 2012 (1)
- 18: Playa Del Carmen – Dive Report (1)
- December 2011 (3)
- November 2011 (2)
- 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)
- August 2011 (3)
- July 2011 (1)
- June 2011 (3)
- May 2011 (4)
- April 2011 (1)
- 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)
- 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)
- November 2010 (4)
- 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)
- 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 (138)
- 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)
- September 2009 (3)
- August 2009 (1)
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