asked on April 14, 2023
Hi,
Since I've been having no luck getting Flexmonster working using the DLL deployment I am now trying the service, again.
I have found a connection string that it looks like works with a client secret:
powerbi://api.powerbi.com/v1.0/myorg/<WORKSPACE_NAME>;initial catalog=<CATALOG>;User Id=app:<APP_ID>@<TENANT_ID>;Password=<CLIENT_SECRET>;
The issue I am having now is starting the server, and am wondering whether there is any additional logging I can get out of it somehow?
I have tried MANY different ports, stopped IIS, stopped my Docker server.
Error:
2023-04-14 15:06:46.1572 | TRACE | Flexmonster Data Speed Accelerator for Miscrosoft SSAS
2023-04-14 15:06:46.1752 | TRACE | Version 2.9.48
2023-04-14 15:06:46.1792 | TRACE |
2023-04-14 15:06:46.4239 | TRACE | Testing connection...
2023-04-14 15:06:51.1118 | TRACE | Data Source connection [POC] - OK
2023-04-14 15:06:51.7994 | TRACE | Starting server...
2023-04-14 15:06:52.0981 | ERROR | Starting server - FAILED
2023-04-14 15:06:52.0981 | INFO | ! PLEASE TRY TO USE ANOTHER PORT IN flexmonster.config FILE !
2023-04-14 15:06:52.1001 | ERROR | Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.StartServer(StartContext context)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.Owin.Hosting.WebApp.StartImplementation(IServiceProvider services, StartOptions options, Action`1 startup)
at Flexmonster.Proxy.FlexmonsterProxy.StartServer()
Please help!
Cheers
⋅ April 14, 2023
Oh, just tried a port below 32000, which are normally for user applications and got it started.
⋅ April 14, 2023
Unfortunately now I get an error further on in the process.
What should the Catalog and Cube be in the reports dataSource configuration?
I have a workspace, datasets, reports, dashboards. I have tried all combinations I can think of without any luck.
Cheers
⋅ April 14, 2023
From putting in rubbish I can see that the Catalog is the name of a dataset.
Trying to home in on what the cube should be now...
⋅ April 14, 2023
Okay, seems that cube is not the obvious thing like a table name.
I think it might be a DAX query, e.g. EVALUATE VALUES(Holdings), but I then get a stream error, with nothing in the logs of use.
This is incredibly frustrating, and there appears to be little in the way of documentation, no forum, and no response here... does support get better if you pay money for it?
⋅ April 14, 2023
Seems I'm getting a 405, method not allowed.
The request is a POST but the response indicates that only GET is supported.
⋅ April 14, 2023
Changing the JavaScript back to have binary: true for the Flexmonster configuration takes me back to the object not found errors, for tables or DAX queries.
Hmm
⋅ April 17, 2023
Hello Martyn,
Thank you for the provided details.
First of all, please set binary: true in the dataSource configuration. It's a flag for the component that the connection will be established via Accelerator.
As for the catalog, it seems that you've identified it correctly. Also, from the logs, I see that one of the catalogs is called "POC".
Finally, regarding the cube. I don't know how exactly it's called in PowerBI, but usually, it's a Model name (in Tabular Model terminology). Maybe you can find these names in PowerBI UI or in Excel.
Hope the above information will help you to move further.
Please let us know in case of any additional questions.
Regards,
Ian
⋅ April 21, 2023
Well, got it sorted in the end.
For those that stumble upon this in the future, in PowerBI datasets have a default model name which is "Model".
This was the breakthrough I needed to be able to properly evaluate Flexmonster with a PowerBI backend.
⋅ April 24, 2023
Hello Martyn,
Thank you for the feedback.
We are glad to hear that it works for you.
As always, feel free to contact us in case other questions arise.
Kind regards,
Nadia
