Going to Microsoft Fabric Usergroup Denmark

By Rob Litjens

July 6, 2023

One of my friends invited me to do something on his Data Fabric usergroup Denmark in August. He wanted me to do a thing else than the Defender stuff. So I opted in for something new. I have read and seen some nice videos about a Open Source tool from Microsoft called Data API Builder.

But, since it is new for me and I am eager to learn it. It is fun to do.

According to the website Lerning path API BUilder you should start with the command dotnet tool install –global Microsoft.DataApiBuilder

In my case, on my windows 11 workstation, i get the message:

C:\\Users\\RobLitjens\\AppData\\Local\\Temp\\c85b8736-cd7f-427a-8656-daa49a8d4a65\\restore.csproj : error NU1101: Unable to find package microsoft.dataapibuilder. No packages exist with this id in source(s): C:\\Program Files\\dotnet\\library-packs, Microsoft Visual Studio Offline Packages
The tool package could not be restored.  
Tool ‘microsoft.dataapibuilder’ failed to install. This failure may have been caused by:

- You are attempting to install a preview release and did not use the –version option to specify the version.
- A package by this name was found, but it was not a .NET tool.
- The required NuGet feed cannot be accessed, perhaps because of an Internet connection problem.
- You mistyped the name of the tool.

For more reasons, including package naming enforcement, visit https://aka.ms/failure-installing-tool

The first time there was an error indicating that I missed a certificate which could be fixed by running dotnet dev-certs https –trust

Unlucky me.. that did not fix the issue.

After reading the errormessage correctly, I investigated the mentioned folder above. After going to the Nuget website, I found a link to download the package. I downloaded the package and moved it to the above folder. I removed the read only blocker and ran the install command again.

You can invoke the tool from this directory using the following commands: ‘dotnet tool run dab’ or ‘dotnet dab’.  
Tool ‘microsoft.dataapibuilder’ (version ‘0.7.6’) was successfully installed. Entry is added to the manifest file C:\\Program Files\\dotnet.config\\dotnet-tools.json.

YES.. It worked like a charm. Up to the next Blog in a few more days.