Latest Power BI and AI articles from RADACAD team
Yesterday I’ve found a very awesome feature in Power Query (Thanks to Matt Masson). The feature is: you can see list of all functions in the Power Query with enumerations and option types with a keyword. I’m personally coming from a developer background, so that option for me looks like the Object Explorer in Visual Read more about How to Get List of All Functions and Invoke Them in Power Query[…]
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[…]
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[…]
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[…]
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[…]
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[…]
Hi folks, I am glad that I’ve been awarded for another year as SQL Server MVP. this is my fourth year as MVP and I’m proud to be part of this community and share technologies that I’m passionate about to people. I believe I’ve got this award because of my contribution on online communities, writing Read more about Recognized as MVP for 2014[…]
2014 is coming and like many of you I have some resolutions for the New Year. Before that I wish you a new year full of success and happiness. Year 2013 was a year that I did some speaking on webinars such as PASS DWBI virtual chapter, I’ve also done some international speaking such as Read more about Year 2014 Resolution[…]
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[…]
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[…]