1 <appSettings file="Cloud.config">
  2 	<!-- Azure订阅id-->
  3 	<add key="subscriptionId" value="" />
  4 	<!-- Azure资源分组名称-->
  5 	<add key="resourceGroup" value="" />
  6 	<!-- Powerbi工作区集合名称 -->
  7 	<add key="workspaceCollectionName" value="" />
  8 	<!-- Powerbi工作区集合名称访问key -->
  9 	<add key="accessKey" value="" />
 10 	<!-- Powerbi工作区id-->
 11 	<add key="workspaceId" value="" />
 12 	<!-- Azure登录账号 -->
 13 	<add key="username" value="" />
 14 	<!-- Azure登录密码 -->
 15 	<add key="password" value="" />
 16 </appSettings>

  1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Threading.Tasks;
  5 using Microsoft.AspNetCore.Mvc;
  6 
  7 namespace WebApplication1.Controllers
  8 {
  9     public class PowerbiController : Controller
 10     {
 11         //工作区集合名称，按自身情况填写
 12         private string workspaceCollection = "";
 13         //工作区id，按自身情况填写
 14         private string workspaceId = "";
 15         //报表id，按自身情况填写
 16         private string reportId = "";
 17         //工作区集合访问key，按自身情况填写
 18         private string token = "";
 19 
 20         public IActionResult Index()
 21         {
 22             //获取报表访问的授权token
 23             var embedToken = PowerBIToken.CreateReportEmbedToken(workspaceCollection, workspaceId, reportId);
 24             var ebToken = embedToken.Generate(token);
 25             ViewBag.StrToken = ebToken;
 26             return View(ViewBag);
 27         }
 28     }
 29 }

  1 <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/jquery/dist/jquery.js"></script>
  2 <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/powerbi-client/dist/powerbi.js"></script>
  3 
  4 <div id="reportContainer"color: #8b0000;">width:100%;height:850px;"></div>
  5 <script>
  6     var token =''@ViewBag.StrToken'';
  7     var embedConfiguration = {
  8         type: ''report'',
  9         accessToken: token,
 10         id: ''b5904f26-47cc-4455-9025-06258ea5d8f5'',
 11         embedUrl: ''https://embedded.powerbi.cn/appTokenReportEmbed''
 12     };
 13 
 14     var reportContainer = $(''#reportContainer'');
 15     var report = powerbi.embed(reportContainer.get(0), embedConfiguration);
 16 </script>

Server Error in '/' Application.
A connection attempt Failed because the connected party did not properly respond after
a period of time,or established connection Failed because connected host has Failed to
respond
Description: An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and where
it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: A connection attempt Failed 
because the connected party did not properly respond after a period of time,or
established connection Failed because connected host has Failed to respond

Source Error:

An unhandled exception was generated during the execution of the current web request.
information regarding the origin and location of the exception can be identified using
the exception stack trace below.

Stack Trace:


[Win32Exception (0x80004005): A connection attempt Failed because the connected party 
did not properly respond after a period of time,or established connection Failed 
because connected host has Failed to respond]

[sqlException (0x80131904): A network-related or instance-specific error occurred 
while establishing a connection to sql Server. The server was not found or was not 
accessible. Verify that the instance name is correct and that sql Server is configured
to allow remote connections. (provider: TCP Provider,error: 0 - A connection attempt
Failed because the connected party did not properly respond after a period of time,or
established connection Failed because connected host has Failed to respond.)

解决方法

Get-AzureRmVMImagePublisher -Location chinaeast

Get-AzureRmVMImageOffer -Location chinaeast -PublisherName ''OpenLogic'' 

Get-AzureRmVMImagesku -Location chinaeast -PublisherName ''OpenLogic'' -Offer CentOS

Get-AzureRMVMImage -location chinaeast -publisherName ''OpenLogic'' -sku ''6.9'' -Offer CentOS

Get-AzureRMVMImage -location chinaeast -publisherName ''OpenLogic'' -sku ''6.9'' -Offer CentOS -Version 6.9.20170411

Login-AzureRmAccount -Environment AzureChinaCloud

#这里设置订阅名称
$subscriptionName = ''订阅名称''

Select-AzureRmSubscription -SubscriptionName $subscriptionName


#需要手动创建虚拟网络
$resourceGroupName = "这里设置资源组"
$virtualNetworkName = "这里设置虚拟网络"

$locationName = "China East"
$virtualNetwork = Get-AzureRmVirtualNetwork -ResourceGroupName $resourceGroupName -Name $virtualNetworkName


#自动创建blob
#$BlobURL = New-AzureRmStorageAccount -Location $locationName -ResourceGroupName $resourceGroupName -Name testvmshstorage -SkuName "Standard_LRS" 
$BlobURL = Get-AzureRmStorageAccount -ResourceGroupName $resourceGroupName -Name testvmshstorage


#新建network interface
#$publicIPAddress = "MyNewPIP"
#$publicIp = New-AzureRmPublicIpAddress -Name $publicIPAddress -ResourceGroupName $ResourceGroupName -Location $locationName -AllocationMethod Dynamic

#虚拟机名称
$vmName = "这里设置虚拟机名称"
$vmSize = "Standard_D3_V2"

#新建Network Security Group:
# Create an inbound network security group rule for port 22
$nsgRuleSSH = New-AzureRmNetworkSecurityRuleConfig -Name default-allow-ssh  -Protocol Tcp `
    -Direction Inbound -Priority 1000 -SourceAddressPrefix * -SourcePortRange * -DestinationAddressPrefix * `
    -DestinationPortRange 22 -Access Allow

$nsgName = $vmName + "-nsg"

# Create a network security group
$nsg = New-AzureRmNetworkSecurityGroup -ResourceGroupName $resourceGroupName -Location $locationName -Name $nsgName -SecurityRules $nsgRuleSSH


#虚拟机创建虚拟网络的第一个子网里
$nicName = $vmName + "-nic"
$networkInterface = New-AzureRmNetworkInterface -ResourceGroupName $resourceGroupName -Name $nicName -Location $locationName -SubnetId $virtualNetwork.Subnets[0].Id -NetworkSecurityGroupId $nsg.Id


#新建可用性组
$avbSetName = "My-AvbSet"
$availabilitySet = New-AzureRmAvailabilitySet -ResourceGroupName $resourceGroupName -Name $avbSetName -Location $locationName

#1.Set the administrator account name and password for the virtual machine.
$username = "Linux用户名";  
$password = ''Linux密码'';  
$securePassword = ConvertTo-SecureString $password -AsPlainText -Force;  
$Cred = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList ($UserName, $securePassword) 


#2.Choose virtual machine size, set computername and credential  
$VM= New-AzureRmVMConfig -VMName $vmName -VMSize $vmSize  -AvailabilitySetID $availabilitySet.Id -ErrorAction Stop 
$VM = Set-AzureRmVMOperatingSystem -VM $VM -Linux -ComputerName $vmName -Credential $cred -ErrorAction Stop 


#3.Choose source image
$VM = Set-AzureRmVMSourceImage -VM $VM -publisherName ''OpenLogic'' -sku ''6.9'' -Offer CentOS -Version 6.9.20170411


#4.Add the network interface to the configuration
$VM = Add-AzureRmVMNetworkInterface -VM $VM -Id $networkInterface.id


#5.Add storage that the virtual hard disk will use.  
$BlobPath = "vhds/"+ $vmName +"-OSDisk.vhd" 
$OSDiskUri = $BlobURL.PrimaryEndpoints.Blob + $BlobPath 
$DiskName = "linuxvmosdisk" 
$VM = Set-AzureRmVMOSDisk -VM $VM -Name $DiskName -VhdUri $OSDiskUri -CreateOption fromImage -ErrorAction Stop 


#6. Create a virtual machine 
New-AzureRmVM -ResourceGroupName $ResourceGroupName -Location $LocationName -VM $VM -ErrorAction Stop 
Write-Host "Successfully created a virtual machine $VMName" -ForegroundColor Green