Excel催化剂开源第47波-Excel与PowerBIDeskTop互通互联之第一篇( 六 )

var portFile = string.Format("{0}\\msmdsrv.port.txt", msmdsrvPath);

if (System.IO.File.Exists(portFile))

{

string sPort = System.IO.File.ReadAllText(portFile, Encoding.Unicode);

string cnnString = cnnString = $"localhost:{sPort}";

using (AMO.Server server = new AMO.Server())

{

server.Connect(cnnString);

string dbName = server.Databases[0].Name;

string modelName = server.Databases[0].Model.Name;

pbidPortTittleMappings.Add(new Entity.PbidFileInfo()

{

FileName = parentTitle.Replace(" - Power BI Desktop", ""),

Port = int.Parse(sPort),

推荐阅读