Find articles, guides, information and community news

Usually, a line visual displays all data points. How do you display it for the last data point only? Similarly, if the Target is available only for one day, how do you show that as a line on all dates?

I wrote a 527 page book on DAX and you won't find the CALCULATE function in the Index. Here's why.

Specific users were not able to open the paginated report in the PBI service which used to work fine in PBI Report Server.

Error Message:

Could not connect to the data source. There was an error communicating with Analysis Services. Please verify that the data source is available, and your credentials are correct. The connection either timed out or was lost.

Discovering patterns in your data is one of the many amazing things you can do within Power BI. Ultimately, with the use of Power BI visualization features, you can showcase patterns in your data really effectively. 

PowerShell Scripts to Export Power BI Reports to PBIX/PDF/PPT and send report as an email attachment to end users.

Connecting to Power BI through XMLA endpoint using SQL Profiler using the dataset name.

Extracting data from the websites could be easy but equally tricky. In this article, I explain how we can get data from multiple webpages in one go, using Power BI parameters.

Analyzing customers is one of the key things in business. Understanding how they behave, why they purchase certain products, or why they stopped buying, etc. can help in your marketing efforts and sales strategies.

In this blog, I will explain how a redundant ‘Return’ statement in a Power BI Measure can cause huge performance issues.

Querying Premium Capacity Health Metrics using XMLA EndPoint

If you ever need to display lower values above higher values in a line chart ("reverse" the y-axis), you will not (to date) find an option out-of-the-box within the default visuals provided by Power BI. The good news is there is a (relativley simple) way of achieving the same effect (at least with a Line Chart visual).

Join us to thank the Power BI Community for 5 Years of contributions and helping others. Get a sneak peek of the event, and to find out more on our blog.

One of the amazing things around the challenge is the variety of participants and their backgrounds. Sharing thoughts and ideas from individuals with different background and expertise allows us to improve our vision of what’s possible and how we can sometimes see the same problem in a different light.

Excel Functions starting with E

Incremental refresh is great in WORM situations. WORM stands for Write Once Read Many.  (There is a variation to that called WORN.)  Examples are industrial sensor data that will be captured once and will never change again.

In the business world, a frequent scenario is data that changes ever so slightly after it has been initially written.  A simple example would be a transaction record that gets its transaction value corrected two weeks after it was originally written.  A more extreme example would be the Sales Stage of an opportunity - that attribute goes through a whole lifecycle before settling down as won or lost.

This article proposes an approach how to handle the described data sources in a way that incremental refresh can be applied.