Tag Archives: sharepoint

  • Connecting to Files in SharePoint & OneDrive with Power BI / Power Query

    image

    I’ve been trying to join multiple Facebook communities that revolve around Power BI topics.

    I was able to join a couple communities that are completely neutral in the sense that they’re not run by a for-profit company, but rather just community members which make things easier as there’s little chance of a conflict of interest with the admins of the group.

    One of these groups is called “Power BI Latinoamerica” which is a Community that primarily speaks the Spanish language and within that group one of the admins posted a video that caught my attention:

    It’s basically a video that showcases a way to connect to an Excel file that is being hosted on OneDrive and while that method is completely valid, I was trying to reference the author of that video to one of my articles about connecting to files hosted on SharePoint and OneDrive and then I realized that I haven’t formally wrote about that topic in my blog…ever.

    Disclaimer, I’ve created multiple videos about this for some of my online courses, so you might’ve seen this method before if you’ve followed any of the courses where I participate.

    It’s time to change that! Let’s find out what’s the easiest and most optimal way to connect to ANY file hosted on OneDrive or SharePoint.

  • Introduction: Microsoft BI with Excel

    image

    Figure shows the scalability of the Powerpivot Solution from Personal, Local Network, Team and finally to the Corporate level

    Since I’m suppose to throw a webinar on Monday but it will only be in Spanish I thought about throwing a personal version of my webinar on Youtube divided by parts so it won’t be too hard to digest.

    Here’s part 1 (about 16 minutes) of the webinar that should be 1 hour long total. Where I’ll cover the following topics:

    • User Driven BI and self-service BI
    • Excel 2010 and Excel 2013 with Powerpivot
    • Pivot Tables with Powerpivot
    • Power View
    • Microsoft Data Explorer (Preview)
    • GeoFlow (Preview)
    • Sharepoint Integration
    • What is DAX?
    • Scalability of the BI solution