marclelijveld / external-tools-model-documentation Goto Github PK

I have set up your application as directed and updated the version of the OELDB connector

The app gave me a sign in which in which i tried
Database : I used data base connection and password -> failed with above error
Windows: I used my windows login -> failed with error above

File or Folder: We couldn't find the folder 'C:\Power BI Model Documenter\ModelDocumenter.vpax'.

Hi Marc, I love the idea of a documenting tool. Already tried another one but to no success. So I was happy to see your anouncement and since I need to deliver some documentation of my last project to a client tomorrow I decided to try your solution immediately.
I downloaded your 3 files and put the JSON in the appropriate Power BI Desktop folder. The other 2 went to C:\temp, so no alterations. After restarting PBI I noticed the new Icon of your tool in the External Tools ribbon and after opening my client project I hit the button.
The MS script screen flashed like you describe but then..... silence. When I go the the C:\temp\ folder there are still the 2 files, but yet nothing happens.
Did I miss something in the description? I opened a PBIX file from a synced sharepoint folder on my laptop. I tried another, earlier project on my HDD but here also nothing happens.
So I guess I missed a step in the process, but which?
BR, Diederik

How can I refresh my documented data model after making changes in the source data model?
The data source setting in the documented model is defaulted to C:\Power BI Model Documenter.

Would be great if the report name could be included on the info tab?

Hello Marc!
Thank you for your model documentation. Can I change data source from local file (C:\Power BI Model Documenter) to Azure Analysis Services, because I want to deploy this PBI to the cloud and configure "Connect Live". I understand that need get DaxVpaView.json and DaxModel.json from Azure Analysis Services without saving on the local disk, but don't undestand how it do.

If you can suggest some other option please tell about it

1. Installed and then double clicked on ModelDocumenter.exe ( as MSI has not generated Short cut )
2. then it shown below mentioned Error.

Hi @marclelijveld ,

I am able to get all the way through the ModelDocumentationTemplate step in the process you outlined at https://data-marc.com/2020/07/28/external-tools-document-your-power-bi-model/

After that I get the Refresh Failed with a handful of errors resembling:
Tables - Query 'Tables' (step 'Renamed Columns1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
and
Loading blocked by failures with other queries.

I have tried all the different authentication methods, but the one piece that looks different is instead of connecting to localhost it's trying to connect to MSOLAP.8 (see screenshot)

Does this tool need admin privileges to a SQL Server Database? Or should it be trying to connect to the Tabular Model running locally in the Power BI Desktop File?

Thanks for any help you can provide!

I have a Power BI report that connects to a SSAS on-prem database that has spaces in the name. The current PowerShell script only uses the first word as the database name.

Log:

Host Application: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe C:\temp\Data-Marc_WriteConnectionDetailsToFile.ps1 server_name My database name
Your Power BI Model currently runs with the following connection details:
Server:  server_name
Database:  My

This is the code that picks up the database name:
$DatabaseName = $args[1]

I'm not a PowerShell expert, but I was able to fix this with the following code:

$DatabaseName = $args[1]
for ($i = 2; $i -lt $args.count; $i += 1)
{
    $DatabaseName = $DatabaseName + ' ' + $args[$i]
}

Marc,

First, I want to thank you for providing this fantastic tool. I am absolutely loving the flexibility and excited to finally have dataset documentation.

As for this question/request...I currently support 16 reports. I would like to run the Model Documenter for each and combine all the models into one dataset so I can report on all 16 models in one documentation report. Do you have any suggestions on how to accomplish this?

Picture of redesigned PBIT file as tax:

Thanks, Joy

I get this error: Error 0x0003: Error exporting vpax file.
Apparently due to I have an aggregated column.
error message (translated from Danish): The [Lead Dimensions] column is part of a composite key, but not all columns in the composite key are in the expression or dependent expression.

The list of measures presented in the Excel Model Documentation Template shows an incomplete list. This only happens in case when a measure table is used.

Issue only occurs with the Excel template. The Power BI template still shows a full list of measures.

When lauching the downloaded file, I get the above message, as you also describes in the FAQ-page. But after clicking 'More info', I still can't proceed. The [Don't Run] button is still my only option.
Can a certificate, or something else, be added to prevent this block of installation?

--- ModelDocumenter 2.0 for.Net (v4.0.30319)

Successfully loaded plugin CommandLineArgumentsParser, Version=3.0.22.0, Culture=neutral, PublicKeyToken=2990a79b704d8378 from assembly CommandLineArgumentsParser.dll
Successfully loaded plugin Dax.Metadata, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Metadata.dll
Successfully loaded plugin Dax.Model.Extractor, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Model.Extractor.dll
Successfully loaded plugin Dax.ViewVpaExport, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.ViewVpaExport.dll
Successfully loaded plugin Dax.Vpax, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Vpax.dll
Successfully loaded plugin Microsoft.AnalysisServices.AdomdClient, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.AdomdClient.dll
Successfully loaded plugin Microsoft.AnalysisServices.Core, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Core.dll
Successfully loaded plugin Microsoft.AnalysisServices, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.dll
Successfully loaded plugin Microsoft.AnalysisServices.SPClient.Interfaces, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.SPClient.Interfaces.dll
Successfully loaded plugin Microsoft.AnalysisServices.Tabular, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Tabular.dll
Successfully loaded plugin Microsoft.AnalysisServices.Tabular.Json, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Tabular.Json.dll
Successfully loaded plugin netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51 from assembly netstandard.dll
Successfully loaded plugin Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed from assembly Newtonsoft.Json.dll
Successfully loaded plugin System.Diagnostics.Tracing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from assembly System.Diagnostics.Tracing.dll
Successfully loaded plugin System.IO.Compression, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from assembly System.IO.Compression.dll
Successfully loaded plugin System.IO.Compression.FileSystem, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from assembly System.IO.Compression.FileSystem.dll
Successfully loaded plugin System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from assembly System.Net.Http.dll
Parsing results:
Command line:
--server localhost:51725 --database 8eab1147-814f-4e31-b083-f54cca224103 --filename c:\Power BI Model Documenter\ModelDocumenter.vpax --pbitemplate C:\Program Files\PowerBI tips Business Ops\resources\static\external-tools\020__Data_Marc\model-documenterV2\ModelDocumentationTemplate_v2.0.1.pbit

    Parsed Arguments:

Argument: s(server), type: String, value: localhost:51725 (converted from: localhost:51725)
Argument: d(database), type: String, value: 8eab1147-814f-4e31-b083-f54cca224103 (converted from: 8eab1147-814f-4e31-b083-f54cca224103)
Argument: f(filename), type: String, value: c:\Power BI Model Documenter\ModelDocumenter.vpax (converted from: c:\Power BI Model Documenter\ModelDocumenter.vpax)
Argument: p(pbitemplate), type: String, value: C:\Program Files\PowerBI tips Business Ops\resources\static\external-tools\020__Data_Marc\model-documenterV2\ModelDocumentationTemplate_v2.0.1.pbit (converted from: C:\Program Files\PowerBI tips Business Ops\resources\static\external-tools\020__Data_Marc\model-documenterV2\ModelDocumentationTemplate_v2.0.1.pbit)

    Arguments not specified:

    Additional arguments:

Query (12, 91) Column [Parameter Slicer] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.
Error 0x0003: Error exporting vpax file.

I have two perspectives in my SSAS database. When I try to connect, I get errors. I was able to modify the connection string to include the name of my perspective but it wasn't intuitive. The connection property is "Cube=perspectivename". If there's an easy way to add it, that would be great.

https://docs.microsoft.com/en-us/analysis-services/instances/connection-string-properties-analysis-services?view=asallproducts-allversions#cube

hi, Axis is a table to use a slicer to let the user select a measure to apply to a visualization as following
Axis = {
("Topic", NAMEOF('dimTopic'[Topic]), 0),
("Entity", NAMEOF('Ratings'[Entity]), 1)
}
above error is shown and nothing more happens

The excel template file is a little behind on the Power BI template file. This is known and will be fixed in the future.

Currently missing in the Excel template:

• Row Level Security roles and expressions.

Based on feedback from @FilK78 in issue #22, It turns out that descriptions for Columns are missing.

Power BI removes tailing/leading spaces automatically when displaying in a table visual.
this is annoying if you have formatted your DAX code to be easy to read.
to avoid this, you can replace spaces with another UTF-8 symbol space separator like this: --> <-- (the gap between the arrows looks like a space but is another unicode charater
discribede here:

= Table.ReplaceValue(#"Changed Type"," "," ",Replacer.ReplaceText,{"Measure Expression"})

Hello,

Getting the above error. I do have other tools installed and load fine. Error says json file is incorrect.

I have the latest version of PBI Desktop 2.92.943.0 64-bit (April 2021) and using 1.2 of the json file.

The other two files are in the c:\temp folder.

ON the relationships table of the PBIT/PBIX template

ToColumn = LOOKUPVALUE ( 'Columns Metadata'[Table], 'Columns Metadata'[ColumnID], 'Relationships'[ToColumnID] )

Should this not return Column Name and not the Table Name

Should be
FromColumn = LOOKUPVALUE ( 'Columns Metadata'[Column], 'Columns Metadata'[ColumnID], 'Relationships'[FromColumnID] )

Same applied to the FromColumn

Is there a way to capture the Ordinal Position of Calculation Items within a Calculation Group? I poked around the data model looking for a Sort, Ordinal, or ID field representing the Ordinal Position of items within the group, but it didn't jump out at me.

See the first screenshot with red numbered bullet points for the Ordinal Position value as displayed in Tabular Editor.

Thanks!

I am fan of the V1 Model Documentation Tool. It is built into our deployment standards as part of our Enterprise BI process. I downloaded V2 and got it running nice and quick. It looks super promissing. The biggest thing that is missing is the ability to View/Copy the "Column Expression" string value. Similar to how can be done on the Table Expression, I need this functionality for Column Expression.

After generating the documentation, I added a "Colmn Expr." hidden page to be used as a Drill Through from the Columns page (Column Name). But I do not know where the PBIT file is that this tool uses. Since the new tool uses a more complicated way of executing, I don't know who to modify the PBIT file to add this customization.

1. How can I customize the PBIT?
2. OR, Can you add the "Colmn Expression Copy/Paste feature"?

Github Documentation

https://github.com/marclelijveld/External-Tools-Model-Documentation/wiki/1.-Introduction-to-the-Power-BI-Model-Documenter#columns

Customization Example

I'm getting below error
DataSource.Error: OLE DB: Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect

Do I need to pass the "%server%" & "%database%" value in .ps1 script ? can't find server and DB details. Could you please share what values we need to pass in ?

Hi, Is there a way to capture Incremental Refresh information for each table with this tool? Thank you!

Hi Marc,

First of all thanks for this amazing tool!

Just ran into the 3rd issue described on the FAQ, where the PowerShell window pops up but no action happens afterward.

I am not a developer so I don't feel comfortable playing with the PowerSheel configuration, and wondered if adding the following line (see image below) would work in bypassing the execution policies? As you see just picked the idea from another external tool that works with my current setup (Hot Swap Connections).

Thanks again for your time!

Hi,

I'm using the new Field Parameter feature in the latest May 2022 release of Power BI. When I try to use Model Documenter I get the following error :
Error 0x0003: Error exporting vpax file.

It works correctly with a model without any field parameter, and when I add one field parameter, I get the error.

In DAX Studio, if I Export Metrics I get the following error message :

Thanks for your help,

Charles

Hi! I installed the latest version of the model documenter, tried to run it, and I get the following error. See below.

A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"bc1dartprod.database.windows.net","database":"bc1dartprod-1"},"authentication":null,"query":null}'.
The XML for Analysis request timed out before it was completed. Timeout value: 3600 sec.
Error 0x0003: Error exporting vpax file.

Hello!

I attempted to start using the new version of the tool this afternoon. I installed using the v2.0.0 msi file. I see the icon in External Tools, but I was met with this error when trying to run the tool:

Thank you for your help.

Best,
Matt

My fact table has a datetime field (PK_Timestamp) that is joined to the date table. PK_Timestamp is a renamed copy of another date in the fact table. This field is preventing the vpak file export.

Hi there, I am stuck with an error when trying to do a refresh. It says that there are pending changes in your queries that haven't been applied and when I click apply changes, it's complaining Query 'Tables' (step 'Renamed Columns1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Kindly see below screenshot.

Hello Marc, first of all thanks a lot for your work it looks great !

In order to document several reports I changed the location of the C:\Power BI Model Documenter folder.
I updated the new path in the Data source settings but when refreshing the data I got this issue: The key didn't match any rows in the table. Do you have any idea of a parameter I forgot to update ?

Thanks a lot for your help !

Anatole

Hi, is it possible to create a portable version of the software, so we don't need admin rights to install it. Tabular editor (amongst many others) does this so I'm sure the skills will be relatively easy to get hold of :)

First of all, Kudos! You've done a great job with the tool!

I ran across a couple of things I needed to tweak to get it to work for me. I'll post them separately.

I have a database name of "Finance V2" that is showing in the .json file as just "Finance". I'm hoping this is an easy fix.

Hi!

I have read your article about connecting the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services (https://data-marc.com/2022/11/22/connect-the-power-bi-model-documenter-to-existing-data-models-in-the-power-bi-service-or-analysis-services/), and followed the steps.

I was hoping it would allow me to achieve my goal to connect the model documenter report to the data model dataset such that whenever updates are applied to the dataset, the data model documenter file updates automatically to reflect these updates.

However, when I ran the model documenter report and published it to a workspace in the Power BI Service, I noticed that in the "lineage view" of the workspace, instead of the model documenter report being connected to the data model (as I had expected), something different happened. Below the data model and all of its reports, I saw a new sequence of Source Folder -> Model Documenter Dataset -> Model Documenter Report was added. Please see the "current state" and "desired state" screenshots to better understand what happened.

Moreover, when I tried to refresh the data model dataset, I got a "Something went wrong, your data gateway (personal mode) is offline or could not be reached. Please try again later or contact support." error message.

I would like to know if there is a way to connect the data model documenter report directly, as illustrated in the "desired state" attachment.

Current State:

Desired State:

Hi,

I am proposing a small improvement to the "Partitions & policies" and "Tooltip-Table" pages to improve the visibility of partitions which were never refreshed and also ability to only select such partitions.

In case the partition was never refreshed, instead of showing default date in the table-partition tooltip:

show some sort of indicator that it was never refreshed similar to as SSMS shows:

we could show something like this:

A possible implementation could be to use a custom measure for "refreshed Time" instead of the column:
{Slctd} refreshed Time = IF ( ISBLANK ( SELECTEDVALUE ( Partitions[state] ) ), "Never", FORMAT ( SELECTEDVALUE ( Partitions[refreshed Time] ), "dd.mmm.yyyy hh:nn" ) )

Additional slicer in the "Partitions & policies" would also help to filter only the partitions which were never refreshed (could use the original partition state column):

For the slicer to work properly, we would need to filter table visual accordingly, as the Table Name and and Partition State are coming from different tables. This could be done simply by putting "# Partitions" measure in the visual level filters and applying "Is not blank" filter.

Thanks :)

Please, advise where in Power BI should I put description to the table to see it in documentation? I would like to fill in [Description] column in TablesMetadata

I am sure I am missing something stupid, but I cannot find the Ps1 anywhere and I suspect it's causing errors on launch from external tools.

I have searched and browsed both locally off the extracted zip and in this repo and I can't see it anywhere? I may have missed a file type rename step or something in the doco so sorry if so.

Hello Marc,

As discussed on your awesome website, please add the possibility to document the current open Power BI file instead of creating a new one.

Getting an error message when running the PBI Documenter tool for one of our reports. This particular error message relates to the new field parameter feature, which we have implemented in the report.

What is causing this error? How can I correct this so that PBI Documenter tool can be executed successfully?

Query (41, 87) Column [Dynamic VALUES] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.
Error 0x0003: Error exporting vpax file.

PBI Desktop

Here is some information concerning the DAX table with documentation errors.

'Dynamic VALUES' := 
{
    ("Disposal (groups)", NAMEOF('Disposal'[Disposal (groups)]), 0),
    ("Company (clean)", NAMEOF('Company'[Company (clean)]), 1),
    ("Operator (clean)", NAMEOF('Operator'[Operator (clean)]), 2),
    ("Hauler (clean)", NAMEOF('Hauler'[Hauler (clean)]), 3),
    ("Meter", NAMEOF('Meters Isometry'[Meter]), 4),
    ("Disposal (unified_name)", NAMEOF('Disposal'[Disposal (unified_name)]), 5),
    ("Company (unified_name)", NAMEOF('Company'[Company (company_unified_name)]), 6),
    ("Operator (unified_name)", NAMEOF('Operator'[Operator (company_unified_name)]), 7),
    ("Hauler (unified_name)", NAMEOF('Hauler'[Hauler (company_unified_name)]), 8),
    ("Business Entity", NAMEOF('Piped Trucked Volume'[business_entity]), 9),
    ("Gathering Type", NAMEOF('Piped Trucked Volume'[gathering_type]), 10),
    ("BWM Entity", NAMEOF('Disposal Attributes (calc field)'[BWM Entity]), 11),
    ("BWM Company", NAMEOF('Disposal Attributes (calc field)'[BWM Company]), 12),
    ("Tie In Type", NAMEOF('Meters Isometry'[Tie In Type]), 13)
}

Hi,
When connecting to one my SSAS Tab cube via Power BI Dataset, we have encountered this error.

Error message when loading external tool json : Data-Marc_ModelDocumentor.pbitool.json

Error message : invalid JSON

Power BI Desktop Release:
December 2020

Product Version:
2.88.1144.0 (20.12) (x64)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

Peak Virtual Memory:
38.9 GB

Private Memory:
684 MB

Peak Working Set:
986 MB

IE Version:
11.1577.17763.0

The relationship between the Columns and Columns Metadata tables seems to be off. The [Column_ID] in the [Columns] table is a text field where the [ColumnID] in the [Columns Metadata] table is a numeric field.

Is there a better way to relate these tables?

Microsoft Defender prevents the installation:
I press More and Install Anyway.

Then it asks for admin user name and password.
My account has admin permissions, but perhaps there is some bug in Defender as it rejects my account id and pw.
Could you post a full installation package instead or in addition?

I am getting an error message when running the PBI Documenter tool for one of our reports. This particular error message happens when I run the model documenter on in a PBIX file connected to live PBI dataset.

According to the Wiki page, it sounds like Live Dataset Connection is supported. I am using PBI Dataset in the report, not Analysis Services connector.

If you run the Model Documenter from Power BI Desktop directly, you will most likely see a GUID presented. If you run the Model Documenter from Desktop connected to an existing model in the Power BI Service using the Analysis Services connector (live connection), the name of the data model will appear.

What is causing this error? How can I correct this so that PBI Documenter tool can be executed successfully?

Please advise.

Thanks,
Brian (sherlockspreadsheets)

ERROR:

The remote server returned an error: (401) Unauthorized.
Error 0x0003: Error exporting vpax file.

I got this error and couldn't find it in the FAQ.

Here's the entire log:

--- ModelDocumenter 2.0 for.Net (v4.0.30319)

Successfully loaded plugin CommandLineArgumentsParser, Version=3.0.22.0, Culture=neutral, PublicKeyToken=2990a79b704d8378 from assembly CommandLineArgumentsParser.dll
Successfully loaded plugin Dax.Metadata, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Metadata.dll
Successfully loaded plugin Dax.Model.Extractor, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Model.Extractor.dll
Successfully loaded plugin Dax.ViewVpaExport, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.ViewVpaExport.dll
Successfully loaded plugin Dax.Vpax, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null from assembly Dax.Vpax.dll
Successfully loaded plugin Microsoft.AnalysisServices.AdomdClient, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.AdomdClient.dll
Successfully loaded plugin Microsoft.AnalysisServices.Core, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Core.dll
Successfully loaded plugin Microsoft.AnalysisServices, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.dll
Successfully loaded plugin Microsoft.AnalysisServices.SPClient.Interfaces, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.SPClient.Interfaces.dll
Successfully loaded plugin Microsoft.AnalysisServices.Tabular, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Tabular.dll
Successfully loaded plugin Microsoft.AnalysisServices.Tabular.Json, Version=19.27.2.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from assembly Microsoft.AnalysisServices.Tabular.Json.dll
Successfully loaded plugin netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51 from assembly netstandard.dll
Successfully loaded plugin Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed from assembly Newtonsoft.Json.dll
Successfully loaded plugin System.Diagnostics.Tracing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from assembly System.Diagnostics.Tracing.dll
Successfully loaded plugin System.IO.Compression, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from assembly System.IO.Compression.dll
Successfully loaded plugin System.IO.Compression.FileSystem, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 from assembly System.IO.Compression.FileSystem.dll
Successfully loaded plugin System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a from assembly System.Net.Http.dll
Argument s(server) is not marked as optional and was not found on the command line.

Usage:
-s, --server... This parameter specifies the server name.

    -d, --database... This parameter specifies the database name.

    -f, --filename[optional]... This parameter specifies the export filename.

    -p, --pbitemplate... This parameter specifies the location of the power bi template file.

Error 0x0001: One or more arguments are not correct.