Posts

Showing posts from May, 2022

Deep Dive into Power Query and M Programming

This Dev camp session will be led by Alex Power from the Power BI CAT team. Alex will teach you how to get started with creating custom functions to aid in the reusability of transformation patterns and how to add robust documentation to your Power Query queries. As this is a code first session, we’ll explore primitive and structured data types, implicit and explicit return values, the Power Query / M language VS Code extension and more. The information presented in this session will be applicable to all places where Power Query is found. Campers should be familiar with creating and testing queries using Power Query. Previous experience reading and writing M code in the Advanced Editor window is helpful but not required. Attendee Prerequisites : Campers should be familiar with creating and testing queries using Power Query. Previous experience reading and writing M code in the Advanced Editor window is helpful but not required. Click here !  to join us at Power BI Dev Camp on ...

SandDance Power BI Custom Visual updates

Image
In the current version of SandDance during an animated transition, all data points begin animating simultaneously. We now support the ability to customize the order in which each datapoint transitions between views. We call these staggered transitions. Support for background images You can now use an image as the background of a Scatterplot or Stacks chart to help provide additional context to the visualization. This example is a Scatterplot showing house sales data for King County, WA. This example is a Stacks plot of the positions of shots made on a basketball court by  Kobe Bryant , who was a professional basketball player for the Los Angeles Lakers team. New rendering engine We’ve completely re-engineered our WebGL rendering engine. It has two modes: Standard mode can handle many data points while still being responsive and works on mobile devices and lower power GPUs . Enhanced 3D mode adds shadows, emissive lighting, and depth of field effects, and requires a more powerful GP...

New data source and gateway management experience

Image
Recently replaced the “manage gateway” experience with a new interface, making it easier to manage your gateways and data sources. With this new experience, you also get the ability to manage and create the Vnet gateway and use the recently released additional security roles. How to create new data sources Navigate to powerbi.com Navigate to the  Manage gateways  page To create a new data source, click on the  New  button in the top ribbon Select the gateway you want to create a data source for and give the data source a name Select the  Data source type . In this example we are using SQL Add the  Server  and  Database  and fill out the credentials Click on  Create  to create the data source. On success you see a message that the data source was created successfully Optionally, you can also set  Single Sign-On  for specific data sources and the  Privacy level How to view/change setting of data sources Select one of th...