Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our settings, which can be enabled or not. One question remains: How could we check if the tables are V-Order optimized or not? The tables we will … Read more
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. This section covers some considerations for using RLS with the primary Microsoft reporting engines and gives you an idea of things to look for in your reporting engine. Some anti patterns and alternatives to RLS are also examined. … Read more
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays we have an easy-to-use UI feature for the conversion. As I explained on the article about lakehouse and ETL, there are some scenarios where we still need to use notebooks for the conversion. One of these scenarios is … Read more
Some time between January and now, a new preview feature was included in Power BI Portal. It’s a new Manage Connections and Gateway window, still in preview. We can access this option on the Settings button. In the past, the connections were related to on-premises data gateways. For each gateway we could create many connections … Read more
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start playing with this great product. Microsoft Fabric is a very broad product, so it requires some additional configuration for the start of a trial. Configuring the Tenant By default, the Power BI tenants are disable for Microsoft Fabric. … Read more
.In this blog I will illustrate how we can ingest data from a blob storage to a Microsoft Fabric Data Warehouse using T-SQL. Create a new workspace On the left ribbon, click Workspaces. Click the New Workspace button. Provide a name for the workspace. On advanced configuration, ensure you choose Premium by Capacity, and you … Read more
I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time. I would emphasize the performance. The general UI performance seems way better than when it was first released. Let’s talk … Read more
In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The transformations will perform better if they can be converted to a native query, especially a single native query for all transformations. However, this is just a starting point for the optimizations. Sometimes, native queries for … Read more
I wrote before about Automating table Refresh in Power BI. On that article I explained how to schedule a refresh script using the Azure Automation Account. We can improve the automation process even more. If we create a parameterized Powershell script and publish it to github, the script becomes available in the Automation Account gallery. … Read more
On the article Automating table refresh in Power BI I explained many methods to automate refresh of individual objects, which could be tables or partitions. This creates the need of good ways to visualize the last refresh date and time for each partition and table. The portal shows the refresh date/time for the entire dataset, … Read more
Azure Cost Management is in constant evolution to help manage the cost of services in the cloud. Microsoft provides the Azure Cost Management Power BI App to manage cloud costs, but this app only works with Enterprise Agreement accounts. This was a considerable limitation, since many companies use the cloud using Customer Agreement instead of … Read more
Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.… Read more
Log Analytics is a basic tool for the entire Azure environment, I wrote about it before. The possibility to access log analytics data from a tool for analysis, such as Power BI, only increases its importance. There are some options to make this access and we expect these options to improve very soon. Using Notebooks … Read more
.There are some interesting ways to transform queries from Power BI Desktop to Power BI dataflows in the portal. The UI can be a bit confusing. I made some mistakes in the middle as well. Let’s see some options to make the conversion. Leaving Blank Query Blank Create a new dataflow Select Blank Query as … Read more
The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s talk a bit about the story of this conference and I hope this story can provide it’s 2 cents to the build of our new era, at least starting many discussions about do’s and don’ts … Read more
Until now, one common knowledge about Power BI was how Power BI Premium subscription is expensive. We, regular mortals, could only dream with the full set of features offered by Power BI Premium. The new announcement is a complete game changing for the enterprise self-service BI technology: Power BI Premium per User will be available … Read more
Data Lakes are becoming more usual every day and the need for tools to query them also increases. While writing about querying a data lake using Synapse, I stumbled upon a Power BI feature I didn’t know was there. When reading from a data lake, each folder is like a table. We store in the … Read more
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
