Skip to content

Instantly share code, notes, and snippets.

View Fabian-Schmidt's full-sized avatar

Fabian Fabian-Schmidt

  • Berlin
View GitHub Profile
Power BI Connectionstring to dataset without premium. Works with Free tier.
Use `Microsoft.AnalysisServices.AdomdClient.AdomdConnection`
`Data Source=pbiazure://analysis.windows.net:443/powerbi/api;Initial Catalog=<VirtualServerName>-<DatasetId>;Location="<PowerBIClusterUrl>/xmla?vs=<VirtualServerName>&db=<DatasetId>";Password="<PowerBIAccessToken>";Provider=PBIDATASET`
VirtualServerName = `sobe_wowvirtualserver` or `sobe_onpremisevirtualserver`
PowerBIClusterUrl = e.g. `https://wabi-west-europe-d-primary-redirect.analysis.windows.net` and see JS variable in PowerBI portal.
DatasetId = See URL in PowerBI portal when looking at dataset options.
PowerBIAccessToken = Example see JS variable in PowerBI portal.
@Fabian-Schmidt
Fabian-Schmidt / ExtractImagesFromRdl.ps1
Created March 29, 2016 05:41
Extract all images from all SSRS (Sql Server Reporting Serivces) Reports (*.RDL file) in the current folder.
$ErrorActionPreference = 'Stop';
Get-ChildItem -Filter '*.rdl' | ForEach {
$reportFile = $_;
Write-Host $reportFile;
$report = [xml](Get-Content $reportFile);
$report.Report.EmbeddedImages.EmbeddedImage | Foreach {
$imagexml = $_;
$imageextension = $imagexml.MIMEType.Split('/')[1];
$filename = $imagexml.Name + '.' + $imageextension;
Write-Host '->' $filename;