Customer retention refers to the ability of a company or product to retain its customers over some specified period. Here, we will measure how long we were able to retain a customer since its first date of purchase. What Kind of customer we would like to retain.

We couldn't connect to model in Power Bl Service. The dataset may have been deleted, renamed or it is possible that don't have permission to it.No OLE DB Error Information found.

Customer retention refers to the ability of a company or product to retain its customers over some specified period. Here, we will measure how long we were able to retain a customer since its first date of purchase.

Customer retention refers to the ability of a company or product to retain its customers over some specified period. There are many ways to measure the data. In the last blog (blog link), we have checked MoM (Month on Month) Retention. Here, we will go through Period over Period or POP.

Recently, I have noticed that there was a lot of content talking about gzip decompress with Power Query, but I haven't seen someone talking about decompressing .zip files. The truth is that gzip is a most common file extension for data with the Azure suite. We can handle gzip with Azure Data Lake and Azure Data Factory. Anyway, in this article we will check how to decompress a ZIP file to explore your files inside, like a Windows folder in Power Query, in a very similar way as the gzip is done. If you haven't seen how gzip works, you can check this post about it.

When it comes to dealing with DirectQuery, most of us think that columns are not allowed. But this is not true. We can directly create columns to let us explore more. Can we use date table create in Power BI for getting time intelligence?

Continuous streak is needed when you have a set of start and end date with 1-day gap and they need to be combined.

This blog tells you what to do when a Power BI report throws the error "principalobjectattributeaccessset" while refreshing from Power BI Desktop.

When it comes to deal with the direct query, most of us think that columns are not allowed. But this is not true. We can directly create columns to let us explore more.

When it comes to deal with DirectQuery, most of us think that columns are not allowed. But this is not true. We can create columns. Let us explore more.

This post provides a self-contained pbix file for learning/demonstrating basic Power BI concepts.  It requires no external data connections and is easily expandable/adaptable.  I hope the Community finds it useful.  Enjoy!

Power BI Time Intelligence provides powerful functions to deal with Year, Quarter, and Month. But WTD and this Week vs Last Week do not have any out-of-the-box solution. Let’s quickly deal with Week Time Intelligence.

Bad actors are the most frequently occurring alarms which are a nuisance to the operator. Usually, these alarms are broken and their configuration needs fixing e.g. the setpoint is incorrectly set, or the dead band or on/off delay needs modification. It is not a trivial task to count, aggregate and rank alarms over a variable period, especially when the database contains millions of events. This report can be generated within seconds in Power BI using Industrial App Store...

Data historians are used throughout industry for mass-long term storage of time series data. There are a number of historians on the market with varying popularity but one thing they tend to have in common is their lack of integration options to popular visualisation tools such as Microsoft Power BI. Until now....

Power BI has gone through many changes in 2019.  At PowerBI.Tips we've been following along with every new feature release.  So for the beginning of 2020 PowerBI.Tips would like to give  you the top Tips and Tricks of 2019 to enhance your reports.