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 42 – The Power BI Embedded Show

Embedded

This is episode 42 recorded on March 23rd 2018 where John & Jason talk to Megan Assarrane, Senior Product Marketing Manager at Microsoft for Power BI Embedded. We dispel some misunderstandings about embedded licensing, discuss the retirement of the old Workspace Collections product and walk through the awesomeness that is the new Power BI Embedded service.

Show Links:

Power BI Embedded Webpage: https://azure.microsoft.com/en-us/services/power-bi-embedded/
What’s new for Power BI Embedded: https://azure.microsoft.com/en-us/updates/?product=power-bi-embedded
Hands-on embedding tool: https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html
Migration documentation: https://docs.microsoft.com/en-us/azure/power-bi-embedded/migrate-from-power-bi-workspace-collections

Episode 41 – The New Power BI Report Server is Here

This is episode 41 recorded on March 15th 2018… where John & Jason talk to  Riccardo Muti, Principal Group Program Manager at Microsoft for Power BI and SQL Server Reporting Services, about the latest Power BI Report Server release & the direction he sees the product going in the future

 

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

Episode 31 – Power BI Desktop January Update

This is episode 31 recorded on January 9th 2018… where John & Jason talk about the January features updates to Power BI Desktop, some things they noticed in the Desktop client, and some User Voice submissions.

 Reporting

Show and hide pages
Control data label background color for Cartesian and maps visuals
Increase area used for axis labels in charts
Bar/column padding control
Show dates as a hierarchy (preview)
Add an anchor date for relative date slicer
Top N selection in Q&A

Analytics

Correlation coefficient quick measure

Custom Visuals

PowerApps
TreeViz
Funnel with Source by MAQ Software
Box and Whisker chart by MAQ Software
Agility Planning Matrix Light
Image Grid
Gantt Chart by MAQ Software

Data connectivity

Support for Azure Active Directory authentication for Azure SQL Database & Data Warehouse connectors

Other

Advanced language settings for the Windows store app

Power BI Desktop things of note

-Help tab
-Windows Store download was behind the blog post

Previous Month’s Power BI Desktop update episode

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

Power BI User Voice submissions

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32871283-notification-after-updates-have-been-installed

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32871919-display-the-desktop-version

Episode 29 – 2018 Predictions from the Community

This is episode 29 recorded in December 2017… where John & Jason talk to community members about their 2018 predictions & make a few themselves.

A special thank you to Dan Holme for supporting us in this reimaging of his Penton series of Predictions. This was always a fun series of predictions to read, and we hope that you find this episode entertaining to listen to.

Thanks to everyone who contributed a prediction for 2018. Follow them on Twitter and check out their blogs below:

Andy Huneycutt – 5:15

https://twitter.com/AndyHuneycutt

Brian Alderman – 7:16

https://twitter.com/brianalderman
http://www.microtechpoint.com/

Christina Wheeler – 7:38

https://twitter.com/cwheeler76
https://www.sharepointwheeler.com/

Marc D Anderson – 8:20

https://twitter.com/sympmarc
http://sympmarc.com/

Chris McNulty – 9:45

https://twitter.com/cmcnulty2000

Dean Swann –  10:46

https://twitter.com/sdeanswann
https://www.tygraph.com/

Joanne Klein – 11:40

https://twitter.com/JoanneCKlein
https://joannecklein.com/

Jeremy Thake – 12:28

https://twitter.com/jthake
https://jeremythake.com

Susan Hanley –  12:57

https://twitter.com/susanhanley
http://www.susanhanley.com/

Mark Rackley – 13:10

https://twitter.com/mrackley
http://www.paitgroup.com/

Mike Fitzmaurice – 13:48

https://twitter.com/mikefitz
https://www.nintex.com/

Andrew Connell – 14:48

https://twitter.com/andrewconnell
http://www.andrewconnell.com/

Vlad Catrinescu – 15:48

https://twitter.com/vladcatrinescu
https://absolute-sharepoint.com/

David Broussard –  16:02

https://twitter.com/dbroussa
http://blogs.catapultsystems.com/author/dbroussard/

Richard Campbell – 17:10

https://twitter.com/richcampbell
http://runasradio.com/

 

We wish everyone a happy holiday season and a Happy 2018!

 

Episode 28 – December’s SQL Server & Power BI Desktop updates

This is episode 28 recorded on December 14th, 2017… where John & Jason talk about the new SQL Server Management Studio 17.4, a new open source SQL Server CLI, a change to Power BI Premium, and the December updates to Power BI Desktop.

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 

News

Upcoming events

  • Power BI Summit in Dublin – April 24-28 2018
    • Presented by PUG and Dynamic Communities

Related episodes:

Episode 24 – November’s Power BI Desktop update & more
Episode 15 – Microsoft Ignite 2017 Bonus Episode

Listener contribution ask for 2018 Prediction episode

As we close in on the end of 2017 and we decided to do something a bit different with our final episode of the year, episode 29. We are calling it our 2018 Prediction episode. While we were in Chicago two weeks ago we recorded an interview with Paul Schaeflein and also grabbed some interviews with friends from the SharePoint Community and asked them one question: “What is your prediction for 2018?”. It was so much fun that we decided that we should open this up to our listeners to contribute answer to as well.

This is an open ended question that we are not looking to be targeted to Business Intelligence, even though our show is about BI, but instead a more general fun question that we will string together for a fun episode. Our preference is to have this be tech related, however the only off limits topics are politics & religion. We aren’t looking to stir the pot, just have some fun, possibly thought provoking chats.

If you would like to contribute your 2018 prediction please upload a .wav, .mp3, .mp4 or any other video/audio format to http://link.bifocal.show/2018prediction. We will only be using the audio from the file so feel free to make funny faces at us. We are looking to keep each prediction to under 2 minutes, and be sure to tell us & the other listeners who you are!

I also recorded a video about this that you can watch below:

We want to thank Dan Holme for permission to rip of an old idea of his and turn it into a fun end of year episode. When Dan used to write for Penton a few years ago he put out a blog post of predictions for the coming year. Personally, I’ve missed reading that post and we all thought it would make for some fun listening.

FYI, we are going to close submissions for this on December 23rd, 2017 that way our awesome audio engineer can work his magic and not have to work for us on Christmas.

Best,
-jase

Episode 27 – A chat with Paul Schaeflein on Power BI & Microsoft Teams

This is episode 27 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk to Paul Schaeflein about helping people transform applications using Microsoft Teams, authentication stuff using Azure B2B & Paul quizzes us on how people should be using Power BI.

Paul Schaeflein is a solution architect/developer with more than three decades experience in architecting, designing and developing software solutions. This experience covers a vast range of technologies, languages and industries. Paul is an independent consultant, helping organizations of all sizes with their application development, ALM and SharePoint/Office 365 projects. Paul is a top-rated speaker, having presented at SharePoint Evolutions, the Microsoft SharePoint Conference and TechEd conferences, as well as user groups. In recognition of these community efforts, he is recognized as a Most Valuable Professional (MVP). Paul has a blog at http://www.schaeflein.net/blog, and is active on Twitter as @paulschaeflein. You can also reach him at paul@schaeflein.net.

Find out more about Paul at https://www.schaeflein.net/speaker-biography/

Helpful links:

The webinar for B2B (and Flow): https://www.youtube.com/watch?v=AIImcUZyP7U

SharePoint Conference NA: https://www.sharepointna.com use discount code SCHAEFLEIN

Power BI Report Server episode with Chris Finlan

Episode 25 – Power BI Guest Access

This is episode 25 recorded on November 24th, 2017… Black Friday… or as we call it, Analytics Friday… where John & Jason talk about Power BI Guest Access using Azure B2B and some tips, tricks & community shout outs.

 

News

Guest Access now available

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-access-to-intelligence-for-external-guest-users/

  • AAD B2B with Power BI is available starting today.  Read the documentation and try inviting an external user now!
  • For more information and a step-by-step guide to distributing BI content with Power BI and Azure AD B2B read this whitepaper. Also visit Azure documentation for more information on Azure AD B2B.

 

-Power Query Tip – Cached data remembers its source – even after you change it in the Query Editor. You need to make sure it’s totally refreshed.

-Facebook Query has totally changed: https://whitepages.unlimitedviz.com/2017/11/facebook-location-tracking-power-bi/

 

Community shout outs

DigiCert: https://www.digicert.com/

Pluralsight: https://www.pluralsight.com/

RunAs Radio: http://www.runasradio.com/Shows/Show/559

Richard Campbell: https://twitter.com/RichCampbell