[ ] Regression (a behavior that used to work and stopped working in a new release)
[x ] Bug report
[ ] Performance issue
[ ] Feature request
[ ] Documentation issue or request
[ ] Support request => Please do not submit support request here, instead go to https://varigence.com/Forums?forumName=Biml or email support@varigence.com
[ ] Other... Please describe:
Current behavior
When I try to publish a SSAS Tabular model to a a Power BI Premium Workspace, I get a publish failed message. I reported this to Microsoft and their investigation led to them finding fault in the BimlOnlineServices.dll. Below is the response from Microsoft on the issue.
There is a bug in the logic of assembly resolver code in the file BimlOnlineServices.dll.
First they try to match the fully-qualified assembly name [which includes the version] to a particular assembly,
Then, if this is not the case, they will load any assembly that has the same file-name, without verifying that it matche the version, from same directory [see the highlighted part]
public static Assembly OnAssemblyResolve(object sender, ResolveEventArgs e)
{
new StringBuilder();
AssemblyName assemblyName = new AssemblyName(e.Name);
if (assemblyName.FullName == addinAssembly.FullName)
{
return addinAssembly;
}
string text = Path.Combine(addinFolder, assemblyName.Name + ".dll");
if (File.Exists(text))
{
return Assembly.LoadFrom(text);
}
return null;
}
This file appears to be a non-microsoft binary and appears to be used to create SSIS projects. Looking at the assembly version its from year 2016. You may want to check with the provider of this application to see if they have newer version and it doesn’t have this issue. The other option is if you are not using that product you can remove it.
Expected behavior
For the SSAS model to be deployed as it should be.
Minimal reproduction of the problem with instructions
Install BIML Express. Deploy SSAS tabular model to Power BI Premium Workspace. To workaround the issue, I can disable the BIML Express extension and the deployment succeeds.
What is the motivation / use case for changing the behavior?
I want to be able to use BIML Express and Publish Tabular Models to Power BI Premium.
I'm submitting a...
Current behavior
When I try to publish a SSAS Tabular model to a a Power BI Premium Workspace, I get a publish failed message. I reported this to Microsoft and their investigation led to them finding fault in the BimlOnlineServices.dll. Below is the response from Microsoft on the issue.
Then, if this is not the case, they will load any assembly that has the same file-name, without verifying that it matche the version, from same directory [see the highlighted part]
public static Assembly OnAssemblyResolve(object sender, ResolveEventArgs e) { new StringBuilder(); AssemblyName assemblyName = new AssemblyName(e.Name); if (assemblyName.FullName == addinAssembly.FullName) { return addinAssembly; } string text = Path.Combine(addinFolder, assemblyName.Name + ".dll"); if (File.Exists(text)) { return Assembly.LoadFrom(text); } return null; }
This file appears to be a non-microsoft binary and appears to be used to create SSIS projects. Looking at the assembly version its from year 2016. You may want to check with the provider of this application to see if they have newer version and it doesn’t have this issue. The other option is if you are not using that product you can remove it.
Expected behavior
For the SSAS model to be deployed as it should be.
Minimal reproduction of the problem with instructions
Install BIML Express. Deploy SSAS tabular model to Power BI Premium Workspace. To workaround the issue, I can disable the BIML Express extension and the deployment succeeds.
What is the motivation / use case for changing the behavior?
I want to be able to use BIML Express and Publish Tabular Models to Power BI Premium.
Environment