RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Power Query Formula Language M : Table Functions Part 1

In previous post you’ve learned about Formula language of the Power Query known as "M". you’ve learned that M is a functional language that apply data transformations through script. In examples of previous post you’ve learned some of table functions such as Table.AddColumn, Table.Sort, Table.Join, and Table.PrefixColumns. In this post we will discover more table Read more about Power Query Formula Language M : Table Functions Part 1[…]

Power Query Formula Language: M

In previous post, I described what is Power Query, and how we can use that for self service ETL. You’ve how to work with Power Query menus and connect to different data sources, and apply multiple transformations on the data. In this post I’ll go one step closer to the core of Power Query Formula Read more about Power Query Formula Language: M[…]

Tutorial Introduction to Power Query

Power BI is the new self-service BI tools introduced by Microsoft. Power BI comes as part of Office 365 and Excel tools as some Add-Ins. Power Query is one of the main components of Power BI, and the functionality of Power Query is for self-service data transfer and ETL. In this blog post I’ll describe Read more about Tutorial Introduction to Power Query[…]

SSAS Processing Failure; OLE DB or ODBC error – 08001

Today I faced a new error type that I’d never seen before in my many years of experience with SSAS. It was one of the most weird errors that I’ve seen so far. let me explain that in a scenario; I had a SSAS multi-dimensional cube working and fully processing on the DEV server. then Read more about SSAS Processing Failure; OLE DB or ODBC error – 08001[…]

Master Data Services Software Requirements

  In this blog posts I explain what is required for master data services to be configured on a windows (server or client) machine. Required features would be listed and how to install would be discussed in detail. Master Data Services (MDS) is part of SQL Server 2008 R2 or higher. so you would require Read more about Master Data Services Software Requirements[…]

Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years

Almost a year ago I published first version of T-SQL script to generate and populate a general purpose date dimension here. Today I want to publish the second version of that date dimension which has some corrections (fiscal calendar calculation fixed), and additional attributes (such as current year, current month, and current day) Multiple countries Read more about Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years[…]

Format String Issue of SSAS Measures in Excel Front-End

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount Read more about Format String Issue of SSAS Measures in Excel Front-End[…]

Session Materials to Download: Master Data Management with SQL Server 2012

Thanks for all attendees in my session about Master Data Management with SQL Server 2012 as part of NetCom Learning free webinars. In this session below contents covered: Creating Entities for reference data Relationship between entities Business Rules and their usages User Interfaces for working with Master Data Services Hierarchies Integration Views for using in Read more about Session Materials to Download: Master Data Management with SQL Server 2012[…]