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)
  • Customize period comparison in DAX #powerpivot #dax #powerbi

    I have seen many different types of custom calendars implemented in Power Pivot, Tabular, and DAX. I also wrote several articles (week based calendars and time patterns). However, there is a scenario that is hard to manage with the classical approaches, which I discussed in a new article. Suppose you want to implement custom comparisons. For ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 5, 2015
  • Power BI Customer Event on February 24-25, 2015 on Invite Only

    Microsoft recently released a public preview of Power BI Dashboard. This new service is raising interest because of new visualizations and for the openness to developers, thanks to APIs that can be used also for real-time visualizations. Are you interested in Power BI services for your organization? Do you want to provide early feedback to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 13, 2015
  • The Power BI dashboard in public preview - available also without Office #powerbi

    Microsoft released a new version of Power BI in preview mode, including many new visualizations that are immediately available to all existing subscribers also in production, such as the long waited treemap, combo charts (combining line chart and column chart), and more. These features are available only in HTML5 visualizations, so you can only ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 18, 2014
  • Relational Data Lake

    What is a Data Lake? Pentaho CTO James Dixon is credited with coining the term ''Data Lake''. As he describes it in his blog entry, ''If you think of a Data Mart as a store of bottled water – cleansed and packaged and structured for easy consumption – the Data Lake is a large body of water in a more natural state. The contents of the Data ...
    Posted to Jorg Klein (Weblog) by jorg on December 18, 2014
  • BI Announcements at PASS Summit 2014 #sqlpass #powerbi #powerpivot

    This morning the PASS Summit 2014 started in Seattle and during the keynote there was several announcements from Microsoft. I’m considering here only the ones about Business Intelligence (you will find other blogs around about SQL Server). In the coming months, Azure SQL Database will get new features such as column-store indexes, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 5, 2014
  • Power Query support for Analysis Services (MDX)

    Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown: It should be able to query both Multidimensional and Tabular Generates query in MDX (no ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2014
  • First steps with Scheduled Data Refresh for Power Query #powerbi #powerquery

    Just a few days before my session about Power Query at TechEd 2014, Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations. This is a very good news, because it enables the data refresh of a number of different data sources. Even if the number of providers supported ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 6, 2014
  • Upcoming conference speeches and workshops #ssas #tabular #dax #powerpivot

    Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap:PASS Business Analytics Conference 2014 - May 7-9, 2014 - San Jose, CaliforniaQuerying in DAX (Marco Russo)DAX from the Field: Real-World Case Studies (Alberto Ferrari)Microsoft TechEd North ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2014
  • Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

    The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the Power Query window. Consider the following table in Excel: You want to obtain a table containing the number of distinct products bought ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 31, 2014
  • Scheduled Data Refresh in Power BI #powerbi #powerpivot

    Now that Power BI is finally available (I still use terms as “released” for software and “in production” for a service…) I made some test on the new Scheduled Refresh option that you have for your models (other info here. First of all, the Refresh feature within the Excel workbook no longer works, at least when you are using Data Management ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 11, 2014
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement