Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

TedPattison

Power BI Dev Camp First Session Video + Session 2: September 24th Details

Prior to joining Microsoft, I spent 25 years training developers and contributing to Microsoft developer communities. When I joined the Power BI Customer Advisory Team (CAT) earlier this year, I looked for a way to contribute to the Power BI community as I did in my previous life as a Power BI MVP.  I am especially grateful to Kelly Kaye and Sandy Rivas in the Power BI community who helped me bring Power BI Dev Camp to life as a monthly webinar series.

I am thrilled to announce that the video from our first Power BI Dev Camp session titled Developing for Power BI using .NET Core is now available on the Power BI community video gallery.

 

PBIDC1.png

 

This video is accompanied by a hands-on tutorial which teaches campers how to implement Users-Owns-Data embedding with .NET Core 3.1 and Microsoft's newest authentication library, Microsoft.Identity.Web. The tutorial also teaches developers how to migrate from JavaScript to TypeScript when programming the Power BI JavaScript API. We've also made the PowerPoint slides from the session available for download for anyone who wants to review the advanced developer topics and code covered in the video.

So, what's next?

At Power BI Dev Camp, we're excited about our next session titled Writing PowerShell Scripts for Power BI which will run on Thursday, September 24th. In this camp session, we'll explore how to get started writing and testing PowerShell scripts to automate common administrative tasks in a Power BI environment. We'll begin by introducing the Power BI cmdlets library and discussing the various ways to authenticate both as a user and as a service principal. Campers will learn how to use PowerShell to automate common tasks such as uploading PBIX files, patching datasource credentials, updating dataset parameters and refreshing datasets.

The session will also explore advanced scripting techniques using the Invoke-PowerBIRestMethod cmdlet which makes it possible to call Power BI Service API operations directly. Campers will learn how to parse together REST URLs for the Power BI Service API and to convert PowerShell objects into JSON to populate the body of an HTTP request. This, in turn, will allow campers to write PowerShell scripts that take full advantage of what the Power BI Service API has to offer.

What Campers Will Learn:

  • Install the Power BI cmdlet library for PowerShell
  • Authenticate to the Power BI Service as a User and as a Service Principal
  • Write scripts to create new workspaces and to manage workspace users
  • Write scripts to upload PBIX files, patch datasource credentials and refresh datasets
  • Call Power BI Service API operations directly using Invoke-PowerBiRestMethod
  • Export event activity from the Power BI activity log to monitor usage

Session Prerequisites: To make the most of this session, it is recommended (but not required) that campers have prior experience writing and testing PowerShell scripts using the Windows PowerShell Integrated Scripting Environment (ISE).

We hope to see you there. Stay safe and stay hungry.

PowerShellIsFun.png

Comments

Where can I get the link for this one to join ? 

Anonymous
Anonymous

Hi @TedPattison 

Is this the section for Q&A from the live session?

 

I have two problems with Power Shell + PBI:

 

1. Data Source connection of PBI Service Data Model: PbiServiceModelId

https://community.powerbi.com/t5/Power-Query/Power-BI-Service-connection-change-from-dev-to-producti...

 

2. Creating GW datasources without credentials (skipTestConnection or similar):

https://community.powerbi.com/t5/Developer/Gateways-Update-Datasource-how-to-build-the-body-in-Power...

 

Would really appreciate some help here.

 

Best Regards