Power BI

Power BI

9059 bookmarks
Newest
Announcing Microsoft Power Pages: Build secure, low-code websites
Announcing Microsoft Power Pages: Build secure, low-code websites
<p>Today, we are thrilled to announce the preview of Microsoft Power Pages, the fifth product in the Microsoft Power Platform family. Whether you’re a low-code maker or professional developer, this low-code, scalable, and secure solution empowers you to build business centric-websites quickly and easily.</p>
tommypuglia·powerpages.microsoft.com·
Announcing Microsoft Power Pages: Build secure, low-code websites
Architecting for Performance on Databricks SQL
Architecting for Performance on Databricks SQL
Performance tuning for SQL queries and data warehousing is an art that data management folks have been struggling with for decades…
Database Administrators or DBA’s for short, have spent a considerable amount of time, and resources on performance optimizations to make user queries as fast as possible. While some modern data warehouse vendors have promised automatic query optimization, removing the need for your DBA to tune anything.
Honestly, this is what you paid the DBA for, to use their professional judgment on how to make the tables in the warehouse performant, and the best ones did this efficiently, so costs don't grow out of control as the data platform scales up with business growth.
be wary of any vendor that tells you you can get rid of them with their product.
The best DBAs are the ones that you don't even know their names”. This is because if the DBA is great at their job, everything runs fine and no one ever complains, so you don’t know who they are.
A great starting place for DBAs would be the Query History page. The Query History lists all queries that have been executed in that workspace. From there, you can sort, filter, and find troublesome queries in dire need of tuning. When a user complains about query performance, you can go to this page, filter for that user, and observe the queries they have been submitting
With Delta Lake, one of the major innovations is the JSON transaction log to deliver ACID transactions on a data lake. Along with ACID transactions, Delta Lake also collects statistics of the column data in the Parquet files the data is stored
tommypuglia·medium.com·
Architecting for Performance on Databricks SQL
Introducing bulk resubmit and cancel for cloud flows
Introducing bulk resubmit and cancel for cloud flows
Announcing bulk resubmit and cancel Resubmitting or canceling your flows is easy! All you need to do is to go to the Run history page and select the runs you would like to resubmit or cancel. That’s it! Once you have resubmitted or canceled the run, you will be able to see your canceled flows and successful resubmitted flow run on the run history page. Want to learn more about resubmitting or canceling cloud flow runs in bulk? Check out our step-by-step guide here. Got ideas for Power Automate? Let us know! Join the Power automate community and submit ideas, get help, and report issues.
tommypuglia·powerautomate.microsoft.com·
Introducing bulk resubmit and cancel for cloud flows
Latest innovations to scale automation with Microsoft Power Automate
Latest innovations to scale automation with Microsoft Power Automate
Today at Microsoft Build, we’re excited to announce new ways your organization can streamline business processes at scale with Microsoft Power Automate. Be sure to watch the Microsoft Build session, <a href="https://aka.ms/Build22-Automate-SessionInnovations" target="_blank" rel="noopener">Exciting innovations in Power Automate</a>, to learn about the latest innovations we’ve made to help to scale automation across your enterprise easier.
tommypuglia·powerautomate.microsoft.com·
Latest innovations to scale automation with Microsoft Power Automate
Introducing the new Power Automate pane in Power Apps
Introducing the new Power Automate pane in Power Apps
Adding a flow for your Power Apps just got easier! We are happy to announce the new Power Automate pane in the Power Apps Canvas Studio. Without leaving your app, you can now create, edit, view, or add an already built flow from the Power Automate pane.
tommypuglia·powerautomate.microsoft.com·
Introducing the new Power Automate pane in Power Apps
Access Migration to Power Apps and Dataverse is released to General Availability
Access Migration to Power Apps and Dataverse is released to General Availability
Beginning today, Microsoft Access users can migrate their data into Power Apps and Dataverse.  Customers who have the current or monthly channel for Microsoft 365 and Office can update their Microsoft Access to make use of the Dataverse Connector and migration tool. The Access migration tool and connector provided within MS Access streamlines the process of migrating tables, relationships, and data with setup taking just a few minutes, and migration handled for you.
tommypuglia·powerapps.microsoft.com·
Access Migration to Power Apps and Dataverse is released to General Availability
Field Parameters in Power BI
Field Parameters in Power BI
say good bye to bookmarks and selection panes
·troubleshootbi.hashnode.dev·
Field Parameters in Power BI
Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate
Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate
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 repetitive, mundane tasks and processes. The purpose of this blog post is to help you get started running queries against datasets in Power Automate. It covers exporting data into csv files, building a solution to test datasets, and creating BI-driven cloud flows.
·powerbi.microsoft.com·
Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate
Exportable Formatted Data Tables (Preview)
Exportable Formatted Data Tables (Preview)
Users can author formatted tables using a modern low code web-based authoring experience in the Power BI service.
·powerbi.microsoft.com·
Exportable Formatted Data Tables (Preview)
Power BI May 2022 Feature Summary
Power BI May 2022 Feature Summary
Welcome to the May 2022 update. We are thrilled to announce the general availability of Canvas zoom and Data point rectangle select features, Field parameters and Error bars for columns and line combination charts new preview features, new Format pane and managing composite models preview feature updates. There is more to explore, please continue to read on.
·powerbi.microsoft.com·
Power BI May 2022 Feature Summary
Modularization and Iteration in M Query
Modularization and Iteration in M Query
Here is a real-world M Query scenario recently implemented for a client who has signed contracts in PDF format that offers incentives for sales.
·csgpro.com·
Modularization and Iteration in M Query
Adding Dynamic (Model Refresh) Names to Field Parameters! — Havens Consulting
Adding Dynamic (Model Refresh) Names to Field Parameters! — Havens Consulting
Learn how to add dynamic names (labels) to Field Parameters ! During model refreshes the names will update based on specified logic . Which can be very useful for applying time intelligence labels , or other label logic that would benefit from changes during the model refresh cycle. Tun
·havensconsulting.net·
Adding Dynamic (Model Refresh) Names to Field Parameters! — Havens Consulting
(Livestream Replay) Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API? - with Štěpán Rešl — Havens Consulting
(Livestream Replay) Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API? - with Štěpán Rešl — Havens Consulting
ABSTRACT 📝 At the end of last year , one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API . It is an endpoint that allows you to extract data directly from datasets . Although it also brings limitations, I think that its advantages outweigh them. So what
·havensconsulting.net·
(Livestream Replay) Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API? - with Štěpán Rešl — Havens Consulting
Managing Tenant Settings in the Power BI Service — Coates Data Strategies
Managing Tenant Settings in the Power BI Service — Coates Data Strategies
The tenant settings in the admin portal of the Power BI Service are incredibly important. The tenant settings include a wide-ranging number of things that significantly affect the user experience. It’s really important to manage the tenant settings effectively. In this post I’m going to talk about t
·coatesdatastrategies.com·
Managing Tenant Settings in the Power BI Service — Coates Data Strategies
Refresh single table in PBI Dataset from within ETL
Refresh single table in PBI Dataset from within ETL
Case I have one big Power BI dataset with multiple source tables and one of those source tables is refreshed once every hour and all the ot...
·microsoft-bitools.blogspot.com·
Refresh single table in PBI Dataset from within ETL