Automating Your Power BI Refreshes: Synapse Edition
In our previous Power BI automation blog, we utilized the Power Platform in combination with Azure SQL to store refresh history of our datasets leveraging the Power BI REST API when on a Power BI shared capacity. A solution to manage Power BI dataset refreshes is particularly useful when data source refresh times are variable and end users need to know when dataset refreshes are successful. However, Power Automate and Azure SQL create two failure points. This solution also requires additional licensing cost in Power Automate to leverage premium data connectors to Azure SQL. So, how can we consolidate the number of tools we use and at the same time leverage the security features and access controls that Azure provides?
What you must know when building Power BI dataflows routing over the on-premises data gateway
Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know.…
How to Choose the Right Virtual Machines for Your Power BI Gateways
Struggling to choose the right virtual machines for your Power BI Gateways? Worry no more with this insightful blog that will help make the decision easier.
Chris Webb's BI Blog: Calling The Power BI Enhanced Refresh API From Power Automate, Part 1: Creating A Basic Custom Connector
I love the new Power BI Enhanced Refresh API: it allows you to do things like refresh individual tables in your dataset, override incremental refresh policies, control the amount of parallelism, ca…
Chris Webb's BI Blog: Custom Queries For “Detect Data Changes” In Power BI Incremental Refresh
One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and la…
Chris Webb's BI Blog: Calling The Power BI Enhanced Refresh API From Power Automate, Part 3: Incremental Refresh Options
If you’ve read part 1 or part 2 of this series you’ll know how you can create a Power Automate custom connector to call the Power BI Enhanced Refresh API and get fine-grained control ov…
Power BI Data Driven Subscriptions with Power Automate (Report Bursting)
Being able to do a data driven report subscription with Power BI and Paginated reports is a common request we hear from many customers. Let’s say you want to send a PDF version of a report to…
Announcing Public Preview of Multiple Audiences for Power BI Apps
Today, we are excited to announce the public preview of Multiple Audiences in the Power BI Apps, one of the highly requested features from the community. With multiple audiences for an App, now Power BI App author can create multiple audience groups within the same App and assign different permissions to each group.
StrataScratch is a data science interview platform that has over 1000+ real interview questions from top tech companies like Facebook, Amazon, Google, and more.
Microsoft Power BI is a business analytics tool which allows users to gain insight from their data. You can easily create an interactive dashboard by just dragging and dropping data columns into the visualization plane. In this article, I'll show you how to use Python to help you leverage
Connecting Power BI to Microsoft GraphYou are almost near to achieve your goal of becoming Microsoft Power Platform expert. Till now we expect that you have read all the previous blogs and this is our fifth blog. Let have a top-level view of previous blogs.Revision:In first blog we have learned the b
Power BI using Service Principal with Synapse SQL Pool
In this post I will go over a topic that is frequently asked about and that is using a Service Principal account with Power BI when connecting to data sources. Currently today none of the built-in …
Power BI Data Driven Subscriptions with Power Automate – Follow up using Power BI report
In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing a Power BI dataset. The flow referenced an Excel file with the in…
Power BI component for Vue.js applications is now available
We’re thrilled to announce that a new component for embedding Power BI content in Vue.js applications is now available! Vue is an increasingly popular JavaScript framework for building front-end user interfaces and websites.
Power BI Data Driven Subscriptions with Power Automate – Follow up using Dataset
In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing an AAS database. The flow referenced an Excel file with the infor…