This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.

News

Technical reference implementation for enterprise BI and reporting
https://azure.microsoft.com/en-us/blog/technical-reference-implementation-for-enterprise-bi-and-reporting/

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

•     The public preview of the long-awaited High Availability support.
•     The “Additional Logging” setting of the gateway will now include the Mashup engine traces.
•     The gateway will now automatically fall back to communicating through Azure Service Bus using HTTPS if direct TCP fails.
•     The gateway now includes the November version of the Mashup engine.

Power BI Developer community November update
https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-update/

Azure Resource Manager API

• Scale up/ down
• Pause/ start resource
• Create/ Delete resource
• Get capacity information
• Update capacity
• Get capacity list in a resource group/ subscription

….they will add support for ARM PowerShell soon

Cloud Service Provider purchase channel now available

Visual Options menu and Context menu extension

Injecting custom actions into the options & context menus

Preload API for a better loading experience

Update connection string
https://msdn.microsoft.com/en-us/library/mt814715.aspx

RLS support on AS Azure for pre-defined roles

API 1.9 is now available, adding the ability to open the default browser and navigate to a URL
https://github.com/Microsoft/PowerBI-visuals-tools/blob/master/Changelog.md

How to clone workspaces using the API
https://powerbi.microsoft.com/en-us/blog/duplicate-workspaces-using-the-power-bi-rest-apis-a-step-by-step-tutorial/

Microsoft’s best practices for building custom visuals in Power BI
https://community.powerbi.com/t5/Custom-Visuals-Community-Blog/Security-Developer-Guideline/ba-p/217566