Episode 56 – Developer & Gateway news and MVP Renewals

This is episode 56 recorded on July 12th 2018 where John & Jason talk about Microsoft Research Open Data, Developer & Gateway news, Power BI Desktop vs Service, and MVP renewals.

Notes:

Jason & John got renewed as Office Servers & Services MVP! John is now a double MVP in Data Platform for Power BI. Then Microsoft changed the categories again and they are Office Apps & Services MVPs now… either way, we are BACK!

MSR Open Data

https://www.microsoft.com/en-us/research/blog/announcing-microsoft-research-open-data-datasets-by-microsoft-research-now-available-in-the-cloud/

Power BI Desktop vs Power BI Service

https://www.mssqltips.com/sqlservertip/4139/compare-power-bi-desktop-vs-power-bi-online/

Power BI Developer community June update

https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-june-update/

On-premises data gateway June update is now available

https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-update-is-now-available/

Power BI Workspace Collections is being deprecated – was supposed to happen June 30… get out now!!!! Get on Power BI Embedded

End of Microsoft Fiscal, 4th of July, O’Canada Day, and the looming Business Application Summit all lead to slow news time.

Coming events

Business Applications Summit 7/22-7/24 – https://www.microsoft.com/en-us/businessapplicationssummit

SPSNYC 7/28 – http://www.spsevents.org/city/nyc

SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/

SPTechCon 8/26-8/29 – http://www.sptechcon.com/

Microsoft Ignite 9/24-9/28 – https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29 – https://www.sharepointeurope.com/

Ep 54 – Miscellaneous news & the looming Power BI Embedded deadline

This is episode 54 recorded on June 21th 2018… where John & Jason talk about mobile app configuration of PBIRS settings, a new way of analyzing Excel in Power BI, and the upcoming Power BI Embedded deadline.

Show Notes

Report Server configuration with MDM/EMM tools

https://powerbi.microsoft.com/en-us/blog/drill-through-and-report-server-configuration-with-mdm-tools/

 

Analyze in Power BI coming to the SharePoint UI – Kerem Yuceturk

https://techcommunity.microsoft.com/t5/SharePoint-BI/New-feature-Create-Power-BI-reports-from-tables-in-Excel-files/td-p/201843

 

Use Outlook to organize Power BI reports – Chris Finlan

https://christopherfinlan.com/2018/06/11/use-outlook-shortcuts-to-organize-your-favorite-power-bi-reports-and-dashboards/

 

Business Application Summit – Sessions are up

https://www.microsoft.com/en-us/businessapplicationssummit

 

Power BI Embedded deadline is coming up!

https://www.bifocal.show/2018/03/27/episode-42-the-power-bi-embedded-show/

Megan Assarane interview

 

Coming events

Business Applications Summit 7/22-7/24 – https://www.microsoft.com/en-us/businessapplicationssummit

SPSNYC 7/28 – http://www.spsevents.org/city/nyc

SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/

SPTechCon 8/26-8/29 – http://www.sptechcon.com/

Microsoft Ignite 9/24-9/28 – https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29 – https://www.sharepointeurope.com/

Episode 53 – New initiatives

This is episode 53 recorded on June 13th 2018… where John & Jason talk about new initiatives in their world, discussed MyAnalytics, Azure Machine Learning, and some of the Power BI Service limits & what to do about them.

 

Jason – working on:

  • New product launch
  • Changes in my role
    • Microsoft Inspire & Ready
    • Partnerships
    • A renewed focus on process
      • Leads to more Power BI
      • Newly on E5
        • MyAnalytics
  • Summer plans

 

John – working on:

  • Azure ML and ML Studio – why does this stuff matter? The predictive part of BI
  • The PBIX Grow up story. Hitting the limits of the service.
  • tyGraph
    • For SP, OneDrive and Teams
  • New stuff based on CDSA
  • Power of the Cloud – June 22 – https://powerofthecloud.net/

 

Upcoming events

           TSPUG 6/20 – https://www.meetup.com/TorontoSPUG/

SPSNYC 7/28 – http://www.spsevents.org/city/nyc

SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/

SPTechCon 8/26-8/29 – http://www.sptechcon.com/

 

The Intrazone: Episode 6 “The Desktop Diet”

https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/The-Intrazone-episode-6-The-desktop-diet/ba-p/203323

Episode 52 – Power BI Desktop June update

This is episode 52 recorded on June 7th 2018… where John & Jason talk about the new Power BI Desktop update & the role of Power BI Desktop.

Power BI Desktop June Update

Reporting

Custom Visuals

Modeling

Data Connectivity

Other

 

Previous Power BI Desktop Update – May

Episode 51 – Power BI news & updates

This is episode 51 recorded on June 7th 2018… where John & Jason talk about news in the Power BI space, the Power BI Developer community update for May, and some twitter shenanigans.

 

News & Updates

Power BI Developer community May update

Episode 50 – Live from SPC18 in Las Vegas

This is episode 50 recorded live on May 21st 2018… where John & Jason talk the announcements & other things happening at the SharePoint Conference North America in Las Vegas.

Facebook Live show: https://www.facebook.com/bifocalshow/videos/255860991644964/ 

Notes:

  • Power BI Insights baked into lists
  • Was that a modern BDC built in?
  • 3D editor site of course
  • SP2019 – still waiting on deprecation statements for PP and PP4SP
  • Our tutorial…. What were people looking for?

Episode 49 – SPCNA session picks with Liz Sundet

This is episode 49 recorded on May 15th 2018… where John & Jason talk to Liz Sundet, Office Servers & Services MVP from Minnesota, about the upcoming SPCNA Conference in Las Vegas next week and some news related to the upcoming GDPR deadline.

Liz Sundet

Liz is a Microsoft Office Servers and Services MVP and is involved with multiple areas of the business as a consultant for SharePoint and Office 365. Her work includes a variety of aspects from developing strategies to aid in collaboration, identifying best practices for SharePoint and Office 365 to run efficiently and working with multiple teams on identifying needs and areas of improvement. Liz loves a challenge, so everything from a business problem to troubleshooting an error in a system is just another learning opportunity. As a trainer and international speaker, she hopes to inspire others to learn something they can apply to their own work immediately. When she is not working in SharePoint or traveling, you may find her in a variety of activities as diverse as she is: playing music, riding motorcycles, training her dog and even a craft or two. You can follow her on twitter @percusn

Liz’s Picks

Three Must Have SharePoint Workflows with Microsoft Flow Level – Vlad Catrinescu
https://www.sharepointna.com/#!/session/Three%20Must-Have%20SharePoint%20Workflows%20with%20Microsoft%20Flow
5 Simple Ways to Improve Business Productivity with SharePoint, OneDrive, and Microsoft Flow Level: 100 Stephanie Donahue
https://www.sharepointna.com/#!/session/5%20Simple%20ways%20to%20improve%20business%20productivity%20with%20SharePoint,%20OneDrive,%20and%20Microsoft%20Flow
Take a Chance and Hire that  Fine Arts Major Liz Sundet
https://www.sharepointna.com/#!/session/Take%20a%20Chance%20and%20Hire%20that%20Fine%20Arts%20Major

John’s Picks

SharePoint Server 2019: A First Look – Bill Baer & Hani Loza
https://www.sharepointna.com/#!/session/SharePoint%20Server%202019:%20A%20First%20Look
Get the Facts from your SharePoint Site with Analytics, Then Improve It! – Liz Sundet
https://www.sharepointna.com/#!/session/Get%20the%20Facts%20from%20your%20SharePoint%20Site%20with%20Analytics,%20Then%20Improve%20It!
Understanding Office 365 Usage Reporting – Scott Hoag
https://www.sharepointna.com/#!/session/Understanding%20Office%20365%20Usage%20Reporting

Jason’s Picks

Keynote – SharePoint and OneDrive connect your workplace – Jeff Teper, Seth Patton, Omar Shahine, Dan Holme
https://aka.ms/watch/SPVS
Be a SPFx Ninja: with these Performance, Debugging, Logging and Telemetry Tricks! – Andrew Connell
https://www.sharepointna.com/#!/session/Be%20a%20SPFx%20Ninja:%20with%20these%20Performance,%20Debugging,%20Logging%20and%20Telemetry%20Tricks!
Developing SharePoint Framework Web Parts with Power BI Embedding – Ted Pattison
https://www.sharepointna.com/#!/session/Developing%20SharePoint%20Framework%20Web%20Parts%20with%20Power%20BI%20Embedding
Using Flow and Azure Functions to Customize your Site Design – Dave Feldman
https://www.sharepointna.com/#!/session/Using%20Flow%20and%20Azure%20Functions%20to%20Customize%20your%20Site%20Design
Mastering Modern Authentication and Authorization for SharePoint and Office 365 Applications – Eric Shupps
https://www.sharepointna.com/#!/session/Mastering%20Modern%20Authentication%20and%20Authorization%20for%20SharePoint%20and%20Office%20365%20Applications

Episode 45 – All about the new CDSA & CDS-A

This is episode 45 recorded on April 12th, 2018… where John & Jason take a deep dive on the announcements about the new Common Data Service for Analytics (CDSA) and the new Common Data Service for Apps (CDS-A).

CDSA (Common Data Service for Analytics) and CDS-A (Common Data Service for Apps) are NOT built on CDS

CDSA (Applications) is the logical successor to CDS. And to XRM – All about entities.

Business Apps spring update document – https://aka.ms/businessappsreleasenotes

Announcement from the Power BI team
https://powerbi.microsoft.com/en-us/blog/coming-soon-to-power-bi-common-data-service-for-analytics/

Today in the browser you can bring in some data as is (CSV, XLS) & connect to data models.

With CDS-A you get Power Query
– ETL (Power Query) in the cloud
– It’s a Data Lake (warehouses and marts) that you can connect to
– Also includes pre-defined schemas and connectors (specifically  Dynamics)
– Connect data models to it

Power BI Desktop today combines ETL and data modeling. CDS-A can help separate those concerns.

Analytics apps (the successor to solution templates) will build on CDS-A

Power BI video on this page – https://dynamics.microsoft.com/en-us/release/spring-2018-release/

Once loaded, data is referred to as “Data Pools”

Sign up to receive updates on the CDS for Analytics capability

Get notified when Power BI Insights apps become available

Shameless self-promotion

SharePoint Conference North America
May 21-23, 2018
Use discount code JASEHIMM for $50 off

European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Episode 43 – The Power BI Community with Chuck Sterling

This is episode 43 recorded on March 8th 2018… where John & Jason talk to Charles Sterling who runs the MVP Program for the PowerApps, Flow, and Power BI about his experience working at Microsoft, his view of the Power BI Community in the larger Power*s world, and non-NDA stuff about MVP Summit.

Who is Chuck Sterling?

Charles Sterling joined Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

Links:

Episode 32 – Size Matters

This is episode 32 recorded on January 11th 2018… where John & Jason talk about scaling Power BI, it’s limits, and how to overcome them.

iTunes ratings contest

We are actively trying to get our visibility up for the show and one way to accomplish that is through having ratings on iTunes. To that end, we are asking out listeners to take a moment and rate us on iTunes. Once we hit 10 reviews, hopefully before our Feburary 6th show, we are going to raffle off a $50 Amazon gift card to one of the people who rated us. You will need iTunes to be able to do it, but you can find our page here: https://itunes.apple.com/us/podcast/bifocal-clarifying-business-intelligence/id1266308225 

Size & Scale

What are the limits & why?

Free vs Pro vs Dedicated Capacity storage limits by licensing

App Workspaces vs Office 365 Groups vs Teams confusion

Personal storage limit in Power BI is 10GB per user & per Office 365 Group/App Workspace

Personal storage limit in Power BI is 1GB per model

Maximum size of a single data model limit in Dedicated Capacity is now 10GB
-does NOT go against the user’s personal storage limit

Episode 10 – May I see your license please sir?

Moving a PBIX file to AAS

Load your data model to AAS
https://azure.microsoft.com/en-us/blog/import-power-bi-desktop-files-into-azure-analysis-services/

Kasper’s trick to repoint the PBIX
https://www.kasperonbi.com/change-your-power-bi-report-to-point-to-an-external-ssas-model/

Importing from PBI Desktop to SSAS On Prem – BIInsight
http://biinsight.com/import-power-bi-desktop-model-to-ssas-tabular-2017-using-azure-analysis-services/

Other Stuff to check out

Chris McNulty’s post on Tech Community

SPSEvents site

EDX Power BI Course

John & Jason’s upcoming events

SharePointalooza\North American Collaboration Summit
March 2-3, 2018
SharePointFest DC
March 26-30, 2018
SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off
European Collaboration Summit in Mainz, Germany
May 28-30, 2018