m-kovalsky / tabular Goto Github PK

The scrypt to export objects fails.
The error says "Compile failed, custom action contains errors and cannot be saved".
Thanks.

Hello Sir, In this snippet below, it creates a Legacy-Partition for the AggTable by default. I was wondering if it is possible at all to create a M-Partition instead. If so, I would greatly appreciate if you could point me to some documentation to do that. Thanks in advance.

foreach(var p in Model.Tables[tableName].Partitions.ToList()) { var aggPartitionName = p.Name.Replace(tableName,aggTableName); var aggQuery = p.Query.Replace(tableName,aggTableName); var pName = Model.Tables[aggTableName].AddPartition(aggPartitionName); // Update Data Source pName.DataSource = Model.DataSources[dataSource]; // Update Query pName.Query = aggQuery; } // Remove default partition Model.Tables[aggTableName].Partitions[aggTableName].Delete(); }

While my folder path and file name are correct, I get the following error when I try to run the script:

It's just a simple file I created for test purposes and saved locally. Report elements and the data model are in one PBIX file.

When running the script this error comes up at line 25:

When outputting p.Query it returns Null. p is correctly set to the first partition of the fact table.

The way I understand it, it tries to find the query for a partition, but it's empty? I've already setup incremental refresh on the fact table, whch is why the partitions themselves do not have it's own M query. It's in the "SourceExpression" attribute of the table object. Is this why it fails?

I tried run script, but don't work this line.

Michael, first off, your visual object layer script has been amazing for my team and our business.

Over the last few months, I've made a lot of additions (additional object details pulled) and also added a process to combine each export into a single excel file with tabs.

I'm wanting to share, but all my changes have been for Tabular Editor 3 and I can't quite figure out the Tabular Editor 2 errors.

Any chance you can reach out via email at [email protected] or message in Teams at [email protected]? Similar to your current script, I think these changes are super helpful to anyone/any organization and would love to get them in your main script !

Chris

In the Export Report Object you get the columns measures visuals and so on.
But what i don't see are the filter values.

I don't know if this issue should be at report analyzer. That's why I added it here.

Hi,
When importing with TE2, the description field does not update.
The advanced "unsupported filters" is on.
Is there any thing to know ? (only work on api connection (not local model), needs for a specific compiler ?

I'm facing an issue when pointing to a OneDrive path. Have you resolved your issue?

I'm getting an error at line 137: File does not exist. Must use a valid .pbix or .pbit file.

Not facing this issue when moving the file to a local folder.

Hi @m-kovalsky,

Can we run Best practices Analyzer directly on .pbix file instead of .bim or. dataset?

Do we have any approach to convert .pbix to .bim file?

Thanks

Is a Service Principal required for running this script?

As Power BI Admin I still get this:
Error on line 29 ( Model.Database.TOMDatabase.Server.CancelSession(sID);)
The '[email protected]' user does not have permission to perform a cancel operation.

Hi Michael - thanks so much for your scripts. I use several of them and save me a lot of time and efforts.

Is there a way to create parameters in TE using scripts? I was able to create Shared expression but couldn't figure out how to set the kind to M and add Expression via script.

Thanks

Your scripts for exporting/exportings descriptions are very usefull, however it uses the default Excel code page which can be an issue on non English Excel version.

It would be nice to add an origin variable to set the code page (close to other variables definitions) in ExportDescriptions.cs:
object origin = Type.Missing; // 65001 for UTF-8;
and use excelApp.Workbooks.OpenText(textFilePath, origin, 1, ... instead of excelApp.Workbooks.OpenText(textFilePath, Type.Missing, 1, ...

Exporting and importing DisplayFolder could be nice also even if it's not strictely descriptions.

Thanks

Hello @m-kovalsky ,

The script gives an error when I try to run it.

https://github.com/m-kovalsky/Tabular/blob/master/ExportBPAResults.cs

Can you help?

It looks as if from the non-Standard VisualObjects only the "Label" makes it into the final txt file.
All other elements (starting from row 682) don't make it into the final file.

And: For the vcObjects, the extraction path is not correct. The field "FillRule" doesn't exist any more and can simply be deleted.
However, even after that fix, those objects won't make it into the txt currently.

Trying to use the code to export descriptions and getting this error :
I made sure to have the files in that path. Any tips on how to solve? Thanks!

When I view ReportObjects_UnusedObjects.txt, I see columns that are part of RLS or OLS or a relationship, as well as measures that are used for conditional formatting. Is this expected?

My model has two tables:

In addition to the relationship, there's an RLS role, an OLS role, and a table visual with conditional formatting (background color).

I expect to see only [Unused measure] in ReportObjects_UnusedObjects, yet I see everything but 'Table'[Column for a table visual]: ReportObjects_UnusedObjects.txt

Sample PBIX file: Sample for issue 14.zip

In case it matters, I'm connecting to the model locally. The only parameters I changed were pbiFolderName, pbiFile, addPersp (the latter set to true).

Is there something I'm doing incorrectly?

Hello @m-kovalsky ,

While we are integrating the BPA Scan in .NET core project, we are getting the below issue. Can you please help on to fix this issue.
"Unable to load Tabular Model (Compatibility Level 1200+) from .src\model.bim. Error: The type initializer for 'Microsoft.AnalysisServices.Core.Utils' threw an exception".

Hi Michael

Thanks for all the BPA work.

I cannot run the BPA-script that collects info on several model. It says the ObjectReference for TabularModelHandler is null?

I get the following error

On line: foreach (var p in t.Partitions.Where(a => a.DataSource.Name == strdsName).ToList())

I can't determine how the DataSource.name in partition object is resolved. (My C# is limited). But the datasourcename appears to live in the M Script?

Hi,

I have created (used your script) a script to create a data dictionary without using Excel or a live connection.

But i cant get it to work yet.
What i did i created a SQL statement based on your SQL insert script into the a DWH.
But what i did i create a statement and put that in the Partition.

I also create a table and datasource, but in this case there isnt a data source.
And i think its failing because the datasource doenst exists.

Could you help me ?

The script is in the attachtment.

Kind regards,

Ben

Observing cases where the ReportObjects_Visuals.txt from using "Method 2" for multiple .pbix results in all of the pages from the first report also being associated to the second. Then all those pages also being associated to the third report. Then all those pages also being associated to the fourth and so on.

No issue with Method 1 for a single .pbix.

This is an incredibly helpful tool but may create confusion when using across multiple .pbixs.

TE version 2.16.1.

Example: Created 3 .pbixs each having one page. First .pbix shows the one page correctly, but subsequent reports scanned repeat the report + page listed previously.

I am getting an error on line 50. Could you please help me navigate through it?

I don't have one data source but data is pulled in using dataflows and then creating the model in PowerBI