Author Archives: Amine J.

Make no mistake, Power BI and now Fabric represent the data powerhouse for many compagnies around the world. With the Number of users that is growing day after day, Data and Power BI governance becomes a must. One of the pillars for this governance is developing a report using the REST APIs of Power BIContinue reading “Power BI Audit Logs”

This question is very common in Power BI community, Convert Time to Duration or Duration to Time? The answer becomes very simple to resolve once we know that we should start from the Total Seconds in hand. Both of the solution can be done in Power Query as well as using DAX in Power BIContinue reading “Time Conversion”

DAX users in Power bi tend always to do the same mistake, They apply Time Intelligence Functions “TIF” on a column dates that contain duplicate dates or gaps. Wrong, very wrong! If the date column in your model contains duplicate dates then TIF will return an error and if there is gaps in it thenContinue reading “Time intelligence functions”

In my opinion I think the most critical step in developing a report is the decision making on how to connect to data source! Should it be Import, DQ mode and/or both? We cannot say Import is better than DQ or the opposite. Both have their cons and pros. Many report developers jump into theContinue reading “Power Bi Import vs Direct Query mode”

To all finance community and here we are into a new fiscal year. Before we start developing and analyzing all financial statements, should we first thank all bookkeepers that worked hard on their ERPs to adjust and close the GL Accounts for the past year. The financial team will now take over to export dataContinue reading “Financial statements Report”