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 5 (46 total posts)
  • Format measures as dates in Power BI #dax #powerbi

    If you want to format a measure as date in Power BI, you need an expression returning a date/time data type. This is different from what you can do in Power Pivot and in SSAS Tabular, where you can format any numeric expression using a date and/or time format, and the conversion is implicitly done to perform such a visualization. The problem ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 6, 2016
  • New Server Timings features in DAX Studio 2.5.0 #dax #powerbi #ssas #tabular

    Last week, a new version of DAX Studio (2.5.0) has been released. You can find a summary of the new features in the blog post from Darren Gosbell - thanks Darren for your wonderful job with this tool! My small contribution to this tool is mainly in the area of performance analysis. In the last few months, I worked on implementing a support for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 1, 2016
  • Q&A from 24 hour of PASS #pass24hop #powerbi

    One week ago I delivered a session for 24 hour of PASS, the online free event delivered by PASS (recordings are now available), where I introduced my one-day preconference Create a Power BI Solution in one day that I will deliver at PASS Summit 2016 in Seattle on October 25, 2016. As usual, there were too many questions and not enough time, so I ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 14, 2016
  • BLANK and Boolean functions like IF in #dax

    A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example, consider that the result of the following expression is FALSE and not BLANK: IF ( 1 = 1, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 14, 2016
  • Upcoming conference speeches and workshops in 2016 #ssas #tabular #dax #powerpivot #powerbi

    The summer is almost over and while we are working on new content (books and other for www.sqlbi.com), I already have the plans for this Autumn’s conferences. Microsoft Ignite 2016 – September 26-30, Atlanta, GA See what’s new in SQL Server Analysis Services 2016 Tabular Models Review DirectQuery in SSAS 2016, best practices and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 23, 2016
  • Update custom visuals on OKViz (and name survey result) #powerbi

    In the last few days, users of the Synoptic Panel and Smart Filter (custom visuals for Power BI) experienced some issue in the behavior of these components. Changes applied to API and automatic updates pushed through the Microsoft Power BI Gallery created some unexpected problems. Now the components are synchronized on www.okviz.com and the Power ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 2, 2016
  • 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
1 2 3 4 5 Next >
Privacy Statement