Power Platform Community
When building apps, data is usually the core of your experience – and Dataverse is a natural solution for Power Apps. Dataverse gives us a huge breadth of features to work with so we’ve been investing in familiar and intuitive experiences for our users, so that they can get the best out of Dataverse. This week we announce the general availability of our new data focused experiences and we’re excited to give you a tour of the changes here. Updated list of tables When diving into tables you often want to see what’s already available or find previously used tables to continue to edit. We’ve updated the list of tables to make it simpler to find what you need with extensive support for filtering, sorting, search and have provided some key pivots on this list. We’ve also grouped the table commands in familiar ways to make it easy to find the option you’re looking for. The biggest change you’ll notice here is that tables can now be both Opened and Edited. Opening a table will navigate to the table hub and Editing a table will take you to the new full-screen table designer – we’ll have a look at both of these next! Table hub When you open a table, you’ll see a hub layout giving you an overview of the table with its properties and grouped links for related table components (like forms, views or columns). You’ll also see the top 10 rows of data for the table with controls to include other columns that already exist. This view lets you simply update data in a spreadsheet-style mode, and just like a spreadsheet you can quickly add new columns here too. Diving into related table components, like columns, gives you the detail list of those items, with the same powerful sorting, filtering and searching. And to avoid jumping back and forth you can now switch between these lists with a dropdown in the breadcrumb. Table designer When you need to dive into the full data set, you can edit the table in a full-screen experience that gives you access to all the data in the table (of course, limited by the security roles you have!). For those that are more familiar with side-pane experiences around the Power Platform, you can also use the left pane in this view to manage which columns appear on the table as you edit. Create an app quickly Now that you have found or built your table, it is just one-click away to create a new modern app over that table, whether you’re on the table hub or in the full-screen experience – all you need to do is provide a name for your app and we’ll automate all the steps necessary to create the app, add your table to the sitemap with all forms and views available, and bring you into the modern app designer. What’s using this table? Often tables of data support many apps and flows, so to quickly find out what your updates to a table might impact, you can select a command on the table hub to view the list of apps and flows that are Using this table. There is also a quick way to play or edit the apps and flows you find from this view. Columns, data types and formats With this update to tables experiences, we have also focused on columns as they are key to storing meaningful data – the majority of columns created are text, whole number or date/time so these are all readily available in a single-click. However, we know other data types are key to many scenarios, and those can even have multiple formats. We’ve organized these data types and formats in an easy to work with way, as well as adding search to the menu. Formats can now be updated after the column is created (switching between formats in the same data type), we have introduced a new format for text types called Rich text that allows you to store and work with rich data in your apps. Advanced options are hidden by default but if you need to tweak some of this column properties you can expand that section of the panel to access all the other properties that columns support. Choice columns Providing users with a set of choices can really improve an app’s data entry experience and ensures that users are picking from a set list of items. We’ve enhanced the management of these column types to make it easy to sort, drag/drop reorder, set colors and get access to all the other properties of the choice, including support for extending out-of-the-box Status Reasons. Advanced table tools For those makers that are further along their journey with Power Apps and Dataverse, they are often looking for underlying table and column names for their code or integrations, so we’ve added Tools that will copy these names to the clipboard and allow you to open tabs to the table definition or data query APIs. When working with the table in a solution you can browse tables in parent solutions of patches, and you can also review/update managed properties for both the table and all the related table components that support managed properties.
We’re excited to move Enhanced refresh with the Power BI REST API (formerly asynchronous refresh) from public preview to general availability in Power BI Premium, Power BI Premium per User, and Power BI Embedded. As noted in the public...
Model Driven Power Apps
Hemant Gaur, Principal Program Manager, Wednesday, June 1, 2022 Today, we are excited to announce the general availability (GA) of canvas components and component libraries. Canvas components enable low code/no-code developers to build reusable UX components using default Power Apps controls as core building blocks. These custom components can then be shared across app screens or multiple apps both within and across Power Apps environments. Canvas components contributes directly towards Power Apps vision of empowering everyone to build apps by significantly accelerating app development process. Following are the new enhancements which are part of this GA announcement.Support for component library ALMMakers can now package their apps and component libraries inside a single or multiple solutions and import them into a different environment. If a canvas app is using a component library, it is now tracked as a solution dependency. ALM support ensures that the dependency relationship is maintained in the target environment and any further library versions imported via solutions can deliver the updated components to the app. It enables 1st and 3rd party publishers to ship their components and customizable apps as baseline and then service apps by shipping just the updated component library. All standard solution actions such as managed properties, show dependencies, and add required components are supported inline with the Dataverse solution capabilities .You can find more details here – component library application lifecycle management. Component library ALM support. Image/multimedia file support You can now add multimedia files to the components inside a library. These components can then be used by all apps in an environment. Libraries with multimedia files can be moved across environments using the standard component application lifecycle management (ALM).For details please refer to add multimedia to a component, Add images to component Custom pagesCanvas components can be used in model-driven apps using custom pages. Canvas component library provide app makers the ability to create custom components using custom page supported set of controls which includes modern Fluent UI controls. These components can then be reused across custom pages and applications, and can be centrally updated, packaged, and moved using Dataverse solutions.For More information see add canvas components to a custom page for your model-driven app. Fundamentals investments – Performance, reliability and accessibility.Canvas components have seen huge adoption across large and small organizations since our public preview announcement. Components already are being utilized heavily by hundreds of thousands of apps. We have been constantly monitoring user feedback, feature usage, errors and have been shipping weekly updates to improve feature fundamentals. Thanks everyone for helping us take feature to GA. Looking forward to next phase of low code extensibility. Cheers,Hemant Gaur
We are happy to announce that we have just released the May 2022 update for the On-premises data gateway (version 3000.126.8) Download On-Premises Data Gateway (standard Mode). Download On-Premises Data Gateway (Personal Mode). Compatible with May Power BI Desktop This...
As part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline...
We’re excited to bring you a new version of Power BI Report Server this Spring! With the May 2022 update, we have a variety of new enhancements, including Dynamic format strings support, multi row card selection, canvas zoom, updated...
We are happy to announce that the ExecuteQueries REST API is now GA. By using this REST API, you can query datasets in Power BI from practically any modern environment on any platform, as long as you can authenticate...
Less than a year ago, we announced support for automatic aggregations in public preview. Today, we are excited to announce General Availability (GA), along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock...
We are excited to announce you can create composite Power BI models by connecting to SQL Server 2022 Analysis Services tabular models! SQL Server 2022 is available now for public preview and when you upgrade or deploy tabular models...