Storing and using information from a dynamic data source using PBI desktop.

Dear colleague,

Many thanks for detailed post about storing and using information from a dynamic data source. I try to do the same in a little proof of concept at our firm.

I'm struggling with running the script from PowerShell.

The log file stops with this message:

*****************************************

Trying to refresh Power BI now
Connecting to PBI using ADOMD.NET
Quering datasource localhost:61731 for database 4363995e-1009-4db5-9a93-5663e9b889e8
Der Typ [Microsoft.AnalysisServices.AdomdClient.AdomdConnection] kann nicht gefunden werden. Stellen Sie sicher, dass die Assembly, die diesen Typ enthält, geladen wird.

******************************************

I checked with the IT department and I have the rights to access the localhost.

I also verified that these file is available on my pc:

 [System.Reflection.Assembly]::LoadFile("C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies\Microsoft.AnalysisServices.tabular.DLL")

Does anyone have a hint where I could look further to solve this problem?

Many thanks,

Nicole