I am trying to write a little utility as an external tool.
For now I was just trying to connect to the server and get the database model.
This is the code:
using System;
using System.IO;
using Microsoft.AnalysisServices.Tabular;
namespace PbixTool
{
class Program
{
static void Main(string[] args)
{
var server_port = args[0];
var database_name = args[1];
Console.WriteLine($"Server port: {server_port}, Database: {database_name}");
string ConnectionString = "DataSource=" + server_port;
using (Server server = new Server())
{
try
{
server.Connect(ConnectionString);
var db = server.Databases[database_name];
Console.WriteLine(db.Model);
}
catch (Exception ex)
{
//log exceptions somewhere
Console.WriteLine(ex.ToString());
}
}
Console.WriteLine("Press Enter to close this console window.");
Console.ReadLine();
}
}
}
I registered the built exe as an external tool as explained here: Register an external tool.
When I run the external tool from an empty pbix I don't get any error and I get this output:
Server port: localhost:57713, Database: f19f7559-9afc-45ad-8f3b-a7bc98ac400e
Microsoft.AnalysisServices.Tabular.Model
Press Enter to close this console window.
If I then try to create a sample table with enter data in the model, or if I try to run in on any pbix with a model, I get this error:
Server port: localhost:57713, Database: f19f7559-9afc-45ad-8f3b-a7bc98ac400e
Microsoft.AnalysisServices.Tabular.TomInternalException: An internal error has occured.
in Microsoft.AnalysisServices.Tabular.ObjectFactory.CreatePartitionSourceFromType(PartitionSourceType type)
in Microsoft.AnalysisServices.Tabular.Partition.RecreatePartitionSourceIfMismatchWithPartitionType()
in Microsoft.AnalysisServices.Tabular.Partition.ReadAllBodyProperties(IPropertyReader reader)
in Microsoft.AnalysisServices.Tabular.DdlUtil.LoadDataTable(ObjectType objectType, DataTable table, Dictionary`2 objectMap, StringComparerInfo comparerInfo)
in Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
in Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
in Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
in Microsoft.AnalysisServices.Tabular.Database.LoadModel()
in Microsoft.AnalysisServices.Tabular.Database.get_Model()
in PbixSerialize.Program.Main(String[] args) in C:\Users\ABS01\source\repos\PbixSerialize\PbixSerialize\Program.cs:riga 21
Press Enter to close this console window.
In this case I created a table through enter data, named 'Table', with one column 'Column1' and a single value '1'.
Line 21 is
Console.WriteLine(db.Model);
Indeed I get the same error anytime I try to retrieve the Model.
Any idea on how to interpret the error and how to solve it?
