Tag Archive: query

Query-On-Prem-Datasets-from-Power-BI-Cloud

Query On-Prem Datasets from the Power BI Cloud

Here are some notes for connecting Power BI to Analysis Services. Thanks to Microsoft for the helpful presentation on 3/4/2015. Cloud-based BI allows businesses to start doing BI quicker with little to no overhead. One obstacle has been negotiating the… (READ MORE)

Business Intelligence

, , , , , , , , , , , , ,

data-integration-sql-xml-cross-apply

Transformation Pattern with SQL, XML and CROSS APPLY

You don’t have to live with the repeated pain of transforming xml to rowset values when you need data from xml data stores. You also don’t need to transform and copy the data to relational database┬átables in MS SQL Server… (READ MORE)

Data Management, Most Popular

, , , , , , , , , , , , ,