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