THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Power BI   (RSS)
Showing page 1 of 4 (40 total posts)
  • Leverage INTERSECT to apply relationships in DAX

    If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX), you probably use the following pattern relatively often: [Filtered Measure] := CALCULATE (     <target_measure>,     FILTER (         ALL ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 26, 2016
  • Happy Birthday Power BI #powerbi

    Power BI has been on the market one year. My biggest concern, when the product was still in private beta, was the promise of monthly releases made by Microsoft. Today, I can say that the promise was real. I see a long road ahead, in terms of features and possible improvements. But it’s a matter of fact that Power BI is a product with a growing ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2016
  • Free Introducing Power BI eBook and new DAX recorded video course #powerbi #dax

    Microsoft Press released a free eBook you can already download, Introducing Microsoft Power BI, which I and Alberto Ferrari wrote in the last few months. Please note it is a very introductive book, don’t expect an inside-out. As we wrote in the introduction: We wanted to write an introduction to Power BI that covers the basics of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 16, 2016
  • Exploring custom visuals in Power BI

    One of my favourite things about Power BI is its extensibility. For ages I would hear about how good some other self-service reporting platforms were, and how things in the Microsoft space were lacking. Power View, in particular, was frustratingly limited in what you could do with it, and I felt somewhat disappointed. It was good as a data ...
    Posted to Rob Farley (Weblog) by rob_farley on May 10, 2016
  • Leverage Analyze in Excel for your Power Pivot model

    Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does not allow you to connect a live model based on an on-premises SSAS Tabular server through Power BI ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 25, 2016
  • A warm welcome to Power BI Embedded #powerbi

    I wrote this blog post with Alberto Ferrari. A few days ago, during the Build conference, Microsoft announced the availability, although still in preview, of Power BI Embedded. In a few words, Power BI Embedded lets you embed Power BI reports in your application, taking advantage of the tools in Power BI to enrich the analytical power of your ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 6, 2016
  • How to fix #dax time intelligence functions in #powerbi when date table uses a surrogate key

    I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence functions in DAX makes two assumptions: you have a ''full'' date table (all days ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2016
  • A Fitbit report in Power BI for T-SQL Tuesday

    Finding things to publish online for public consumption is something I’m often a bit reluctant to do. Most of my work is for customers, and there’s no way I’m going to share some of their data unless they’ve explicitly allowed it. So when Jorge Segarra (@sqlchicken) posted a challenge to publish a Power BI report on the web for T-SQL Tuesday, I ...
    Posted to Rob Farley (Weblog) by rob_farley on February 15, 2016
  • GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

    If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you get unexpected results or you have performance issues. The new GROUPBY function (also available in SSAS ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 15, 2016
  • Conferences and Training in Australia Feb/Mar 2016 #dax #sqlsaturday

    In a couple of weeks, I will move to Australia for 3 weeks, visiting Melbourne and Sydney for a number of events and training. This is the list of topics in public events you can attend (with link to registration pages – remember that SQL Saturday conferences are free events, but you still have to register first!): UPDATE 2016-02-08 - added a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2016
1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement