Power BI Tutor

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 ...

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...

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...

We are happy to announce that we have just released the April 2022 update for the On-premises data gateway (version  3000.122.7 ) Download On-Premises Data Gateway (standard Mode). Download On-Premises Data Gateway (Personal Mode). Compatible with April Power BI Desktop  This version of the gateway will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/run-time as in the April Power BI Desktop version.

This Dev Camp session teaches developers how to leverage Power BI embedding features for report authoring and customization. Campers will learn how to create a self-service authoring experience using the Power BI report designer by embedding reports in edit mode. Campers will also learn how to program the Power BI JavaScript Authoring API to automate the process of adding pages and visuals to an existing report. Along the way, this session will also explore other report customization techniques such as using custom bookmarks, custom report layouts, and custom report themes. What Campers will learn : • Embed reports in edit mode to enable self-service customization • Allow users to create new reports and to clone existing reports • Add new visuals to report pages using the Power BI JavaScript Authoring API • Use custom bookmarks to capture personalized report settings • Customize visual appearance using custom report layouts Attendee Prerequisites : Campers should have basic knowled...

Welcome to the April 2022 update. We are excited to announce New format pane and Power BI Goals updates, tooltips drill actions support for more build-in visuals, error bars for clustered column and bar charts preview feature, general availability of Dynamic M query parameters. There is more to explore, please continue to read on. Reporting New Format Pane    – Updates Tooltips now support drill actions for matrix, line, and area charts   Updates to required permissions when using composite models on Power BI datasets Error bars for clustered column and bar charts   Bookmark navigator now shows last selected bookmark per group Data preparation Dynamic M query parameters are now generally available Data connectivity Autodesk Construction Cloud (New Connector) Digital Construction Works Insights (Connector Update) Dremio, Dremio Cloud (Connector Updates) Service Power BI Goals updates Bulk updating Updating sharing and access banner Mobile Mobile formatt...