Articles tagged Power BI

25 April 2022
25 April 2022

Power BI Last Refresh Time Visualization Tool

0
2
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
06 September 2021
06 September 2021

Using Power BI to Analyse Azure Costs

0
4
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
24 May 2021
24 May 2021

Using Power BI to Query Log Analytics

0
1
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
26 April 2021
26 April 2021

Malta Data Saturday and Our New Era

0
1
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
08 March 2021
08 March 2021

The Game Changed: Power BI Premium per User

0
4
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
18 January 2021
18 January 2021

Power BI reading Parquet from a Data Lake

0
11
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
04 January 2021
04 January 2021

DAX financial functions: Depreciation calculations

0
4
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
19 September 2020
19 September 2020

DAX financial functions: Loan calculations

0
2
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
02 January 2020
02 January 2020

Power BI and Excel

0
4
Power BI and Excel are tools so close to each other that Power BI was born inside Excel. Power Query, Power Pivot, Power View, they were all Excel plugins before being united and become Power BI. The ability to build an ETL, design a model and generate reports and dashboards with great storytelling make Power … Read more