Quirks of Visual Studio Query Editor working with Analysis Services

Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. Now, … Continue reading Quirks of Visual Studio Query Editor working with Analysis Services

SAP BW Connector for Power BI – Support for additional member properties

October update of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have … Continue reading SAP BW Connector for Power BI – Support for additional member properties