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)
  • 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 TabularGenerates query in MDX (no DAX by ...
    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