m-kovalsky/processingmanager

A tool for managing the processing of Analysis Services, Azure Analysis Services and Power BI Premium models.

processingmanager's Issues

ProcessBatch "token recognition error"

hi Michael,
wonderful script/platform -- awesome job!!!

I ran into a possible issue, it seems trying to execute the command line for SSAS on prem and I get the following errors, even though in the end, the command finishes fine, after some time, with a confirmation:

Tabular Editor 2.15.3 (build 2.15.7767.23827)

Loading custom actions from: C:\Users\xxx\CustomActions.json
line 316:73 token recognition error at: '?'
line 329:78 token recognition error at: '?'
line 353:87 token recognition error at: '?'
line 358:67 token recognition error at: '?'
line 439:106 token recognition error at: '?'
line 506:95 token recognition error at: '?'
line 511:99 token recognition error at: '?'
line 516:71 token recognition error at: '?'
line 1334:71 token recognition error at: '?'
line 1344:85 token recognition error at: '?'
line 1349:76 token recognition error at: '?'
line 1370:65 token recognition error at: '?'
line 1408:93 token recognition error at: '?'
line 1413:95 token recognition error at: '?'
line 1418:106 token recognition error at: '?'
line 1666:67 token recognition error at: '?'
line 1778:69 token recognition error at: '?'
line 1806:70 token recognition error at: '?'
line 1858:89 token recognition error at: '?'
line 1886:69 token recognition error at: '?'
line 1895:67 token recognition error at: '?'
line 1928:85 token recognition error at: '?'
line 316:73 token recognition error at: '?'
line 329:78 token recognition error at: '?'
line 353:87 token recognition error at: '?'
line 358:67 token recognition error at: '?'
line 439:106 token recognition error at: '?'
line 506:95 token recognition error at: '?'
line 511:99 token recognition error at: '?'
line 516:71 token recognition error at: '?'
line 1334:71 token recognition error at: '?'
line 1344:85 token recognition error at: '?'
line 1349:76 token recognition error at: '?'
line 1370:65 token recognition error at: '?'
line 1408:93 token recognition error at: '?'
line 1413:95 token recognition error at: '?'
line 1418:106 token recognition error at: '?'
line 1666:67 token recognition error at: '?'
line 1778:69 token recognition error at: '?'
line 1806:70 token recognition error at: '?'
line 1858:89 token recognition error at: '?'
line 1886:69 token recognition error at: '?'
line 1895:67 token recognition error at: '?'
line 1928:85 token recognition error at: '?'
Loading model...
Loaded script: C:\YYY\ProcessBatches.cs
Executing script 0...
Processing type 'calculate' of the 'CubeName' model has finished in 8 seconds.

any thoughts on what might be going on?
thank you --

Cannot only process partitions

Hi there Michael, thanks for a wonderful tool.

I am trying to just process 2 partitions in PPU in the Power BI Service and when I try and save it from the Window it says I need to select a table as shown below.

If you could please have a look at this.

What I am looking to do, is to process just the incremental partitions in a PPU instance.

Thanks
Gilbert

When selecting specific partition days it is only processing as per the incremental refreshing policy

Hi there, thanks for fixing the previous issue :)

What I now did was to configure the Partitions as shown below

Now when I run the command line prompt, I watch it via SQL Profiler and I see it is not processing the partitions I selected.

And when I review the partitions processed date I can see that the above partitions have not been processed.

If you need anything further for me to help please let me know.

Process automation

HI,
How do I automate this using a scheduler such as SQL Server Agent, or Automic or Control M or Active Batch?
can I schedule some PowerShell script or otherwise embed the execution script?
Can is call this from a task within a SSIS workflow?
Any of the above as either asynchronous or synchronous?
Can I get the error log raised to the caller for reporting when there is an issue?
Thanks