cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Super User IV
Super User IV

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.

Read more...

Microsoft
Microsoft

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.

Read more...

Super User IV
Super User IV

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.

Read more...

Super User IV
Super User IV

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.

Read more...

Super User I
Super User I

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.

Read more...

Super User IV
Super User IV

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?

Read more...

Super User IV
Super User IV

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

Read more...

Microsoft
Microsoft

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

 

Read more...

Super User IV
Super User IV

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.

Read more...

Super User IV
Super User IV

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.

Read more...

Super User III
Super User III

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!

Read more...

Super User IV
Super User IV

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.

Read more...

Helper I
Helper I

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

Read more...

Helper I
Helper I

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

Read more...

MVP

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. 

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.