Clarifying Business Intelligence, Power BI, Office 365, and more
This is episode 124 recorded live at Microsoft Ignite on November 4th, 2019 where John & Jason talk about some new blogs posts from John and interview Arun Ulag, General Manager of Power BI Engineering at Microsoft, about all things Power BI, what announcements they’ve made at Microsoft Ignite, and some glimpses into the future.
Show Notes
Embed paginated reports in your own application for your customers (Preview)
Announcing Enterprise Information Management Capabilities in Power BI
This is episode 120 recorded on October 2nd, 2019 where John & Jason talk about the Microsoft Ignite schedule builder and a whole bunch of news items from the last month.
Power BI Report Server September 2019 Feature Summary
Template apps update (preview) is now available
Paginated Reports in Power BI September 2019 Feature Summary
Power BI Dataflows September 2019 Feature Summary
Announcing the Microsoft Business Applications October Virtual Launch Event
URL parameters for Paginated Reports are now available
What’s new for SQL Server 2019 Reporting Services RC1
What’s new for SQL Server 2019 Analysis Services RC1
The ability to message all Power BI users from the Power BI service
If you run a Power BI platform for a lot of users you should be able to send /push notifications to them. We are currently experiencing high fail rates and it would be great to alert all users that we’re busy looking into it.
Support creating calculation groups in Power BI Desktop
Support the creation of DAX calculation groups in Power BI Desktop – otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.
Even just a simple text window with a script would be fine. You can clean up the UI later.
Thanks.
This is episode 106 recorded on June 11th, 2019 at the Microsoft Business Applications Summit where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the recently release features around Paginated Reports in the Power BI Service, Power BI Report Server, and more.
User Voice Picks
Allow for simpler account switching between tenants
It is next to impossible to switch between accounts/tenants in the Power BI mobile client. The user must first log out of the existing account/tenant, and then establish a connection with the different tenant. This is a multi-multi step process.
Contrast this with the multi tenant capabilities of the Teams mobile app, or of Outlook, SharePoint etc. We need better account switching in the Power BI mobile app.
Add an interface in Power BI Reports for browsing shared datasets on the Report Server.
A current capability we use in Power BI Reports on our Power BI Report Server is consuming Shared Datasets that are already on the server. We should have a “Shared Dataset” connector option in Power BI Optimized for Report Server that helps users identify which Shared Dataset are available on the server and the parameters(if any) are required to use the shared dataset. This would be a similar capability that exists in Report Builder when adding shared datasets.
This could be a simple UI that ultimately results in an OData source using the PBI REST API. This would simplify adding shared datasets rather than forcing users to under the REST API. Seems like a low overhead improvement that has high potential
Paginated reports – please make it available in Pro as well as Premium
Paginated reports – please make it available in Pro as well as Premium .. thank you
Thisis episode 75 recorded on November 9th, 2018 where John & Jason talk aboutthe news coming out of PASS Summit and break down the introduction of Dataflows.
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/
This is episode 73 recorded on October 22nd, 2018 where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the Power BI Report Server, Paginated Report in the cloud via Power BI, and much more.
This is episode 60 recorded on August 7th, 2018 where John & Jason talk about a new initiative for Power BI Beginners & the deprecation and removal of BI Features in SharePoint 2019.
Business Intelligence in SharePoint 2019
What’s deprecated or removed from SharePoint Server 2019 Public Preview
Self-service BI and enterprise reporting on-premises with Power BI Report Server
Upcoming webinar – Building a KPI Scorecard with Custom Visuals in Power BI with Reid Havens
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.
Report Server configuration with MDM/EMM tools
Analyze in Power BI coming to the SharePoint UI – Kerem Yuceturk
Use Outlook to organize Power BI reports – Chris Finlan
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/
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/
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
This is episode 23 recorded on November 7th, 2017… where John & Jason talk to about the new single-sign on methods for the Power BI service and an interview with Dave Feldman, Microsoft MVP from Shire Pharmaceuticals.
News:
Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service
https://powerbi.microsoft.com/en-us/blog/announcing-single-sign-on-support-when-connecting-to-data-sources-from-the-power-bi-service/
“… it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI.”
Config link: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-kerberos-for-sso-pbi-to-on-premises-data/
Support for Single Sign-On is available for the following data sources as of today:
Interview notes:
“Using BI to make intelligent business decisions”TyGraph, HyperFish & onPrem IIS Logs to do proper analysis around what was being used during the planning phases of the integration between Shire & BaxaltaThe analysis fueled Dave’s migration decisionsLooking into the future to multi-geo decision planning for SharePoint Online
Links:
Shire’s Hub and Link Web Parts: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
Hyperfish: https://www.hyperfish.com/
tyGraph: https://www.tygraph.com/
This is episode 22 recorded on November 2nd, 2017… where John & Jason talk to about the brand new release of Power BI Report Server, PowerApps custom visuals, & Power BI Licensing.
Power BI Report Server new version
https://powerbi.microsoft.com/en-us/blog/new-version-of-power-bi-report-server-now-available/
PowerApps Custom Visual
PowerApp on a report, not just a tile
PowerApp visual can be filtered
Another post about licensing
PBI Report Theme Generators
Online – https://powerbi.tips/tools/report-theme-generator-v3/
Excel Based – https://hopeinternational.box.com/s/gd57sn7djq0bs6p2miut62extxdgucwn
Office them to PBI theme converter – https://1drv.ms/u/s!AkRyAgtzGndznMl3VKm1K8YJp0wsHQ
“Everything you wanted to know” Workshops
John speaking at ESPC
SPFest Chicago (use code WHITE for a discount)
SPFest DC (use code WHITE for a discount)
SharePoint Conference North America (use code JASEHIMM for a discount)< /p>
