PowerBI – Number and Currency Formatting

October 31, 2017

After looking for a solution why my Number Formatting did not want to work out…

After creating a new Measure it returned the classing US based formatting.


While I wanted to have the EU formatting in my table.

Power BI Desktop Client Regional Setting :

Even after changing the Power BI Desktop Client settings, it did not take effect Sad smile


Solutions :

Go to Control Panel –> Region –> FORMAT


If this format is not in line with your region it will overrule the Power BI Regional settings ?


So after applying the correct region format settings on OS level, everything appeared as expected Smile

PS : These figures are just demo based Winking smile


PowerShell – Using PoSH SSH Module to access Raspberry Pi3

October 22, 2017

You can use PuTTY to access the RPI3



Or you can use the PoSH-SSH module to do the same.

So let’s give it a try :

If you connect using this command

New-SSHSession -ComputerName  YourRPI3

Don’t use a domain notification for the user, but just the user name.



But further then this you can’t get … in this version of PoSH-SSH, so best use the famous PuTTY tool to connect.

PowerShell – Using PoSH SSH Module to access Synology NAS

October 21, 2017

You can now access any SSH device using the PoSH SSH module.

Let’s give it a try using a Synology NAS Device.

Make sure that you enable the SSH Access Service


Next make sure you have installed the PoSH-SSH module

Find-Module Posh-SSH


Next install it using this command (run as Administrator) :

Find-Module Posh-SSH | Install-Module

After installing you can check the commands available

Get-Command -Module Posh-SSH


Now you are ready to make a connection Smile

New-SSHSession -ComputerName YourNASDeviceNAME


You can check the session info like this

Get-SSHTrustedHost | fl


Let’s run some commands

Invoke-SSHCommand -SessionId 0 -Command "ls -all" | select-Object output -expandproperty output | fl


Or using this format :

$result = Invoke-SSHCommand -Index 0 -Command "uname -a; cd /; pwd; ls /volume1" 


$result = Invoke-SSHCommand -Index 0 -Command "uname -a" 


To stop the session use this command :

Remove-SSHSession -Index 0 -Verbose


Enjoy !!

Windows Server 2016 – Hyper-V installation Issues

October 13, 2017

After installing the Hyper-V feature on a Windows 2016 Server with 1 active NIC.

I got the problem that after the installation I had no network connection anymore …

When I installed it I had remote control over the server that was standing somewhere abroad.

So I lost all connectivity Sad smile


What went wrong and how to fix it !

When installing the Hyper-V Server Role and Feature, I selected the Network Adapter too.


This is where it went wrong… When the server restarted I did not have any network connectivity anymore.

So I had to call someone in locally to uninstall this Feature again, but again you will run into an issue… !


Ones installed one of the problems is that you can’t uninstall the Hyper-V feature anymore.

Using the Dashboard GUI anymore, it will be Grayed Out Sad smile


Therefor I started with first removing the Hyper-V Virtual Switch … But no success.

Solution Steps :

Step A :
Deleted Virtual Switch associated with Physical NIC



Step B :

You need to do this using PowerShell to run this command as Admin

Remove-WindowsFeature -Name Hyper-V

After removing the Feature I still did not have Internet Connectivity ?

Not on LAN and not on Internet ?

Step C :

After activating the second NIC, I gained back network connectivity … Smile

When comparing the 2 NICs setttings.

The one that did NOT connect had the Network Load Balancing (NBL) active.
This must have been activated when installing the Hyper-V feature ?


After deactivating the Network Load Balancing (NBL)

Everything ran again normal…


PS :

if all of this did not work, you can try to go this way.

Deleted the Physical Adapter from Device Management and then Scanned for Hardware changes.

Physical Adapter was found, and settings were back to their original state

Hyper-V on 1 NIC


PowerShell – Database Choise SQLite vs SQLCE

October 12, 2017


Over time I wrote some posts relating to SQLCE as a nice standalone Database platform that can by used in PowerShell or Webmatrix on IIS etc.

Now that MS has announced the end of life of Webmatrix Sad smile

“WebMatrix product support ends on November 1st, 2017”

As Webmatrix runs on MSSQLCE we need to look for alternatives…

“MS SQLCE support will end in July 2021”

One of the most obvious alternative is of course SQLite, which is shipped as part of AutoIT Winking smile


Besides this, SQLite has much more to offer then SQLCE :

Comparison http://erikej.blogspot.be/2011/01/comparison-of-sql-server-compact-4-and.html


As you can see the size limit is 140 TB and unlimited concurrent users !

And it runs on Windows / Linux / Mac … and as well on Mobile devices.

So this will do for a while … Winking smile



1. Download the appropriate .NET Assembly for your environment


2. Run this PS code :

Add-Type -Path "C:\Temp\.NET SQLite Library\System.Data.SQLite.dll" 

$con = New-Object -TypeName System.Data.SQLite.SQLiteConnection
$con.ConnectionString = "Data Source=C:\Temp\.NET SQLite Library\northwindEF.db"


$sql = $con.CreateCommand()
$sql.CommandText = "SELECT * FROM Customers"
$adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql
$data = New-Object System.Data.DataSet


"Rows # :  " + $data.tables.rows.count
$data.tables.rows | Out-GridView # | ft

3. Test it.

Once you run it you can access the SQLite Database lightning fast …




Some more Tips and Tools you can find here :



Enjoy !

Windows 10 – How to reset Local Administrator Pswd

October 7, 2017

Let’s say you need to get access to a PC that has an Administrator password. But you don’t know it… ?

Solution :

This the simple procedure to get in :

1. Get a Boot CD or a Windows installation CD (Boot USB will do as well)

2. Next start up the Boot CD and go to the CMD prompt


3. Go to the the WINDOWS\SYSTEM32\



4. Copy the CMD.EXE to CMD1.EXE and renmame it to UTILMAN.EXE

Normally the Windows KEY + U combination will bring up this screen before you logon.


5. Restart the PC… and press Windows Key + U at logon screen

After the modifications the key combination will bring up the CMD


6. Now use this command to add a new Administrat User :



This will add a new user to with admin rights to the PC to login …

7. Use this command to activate the built in Administrator or reset the password.

NET USER Administrator P@$$w0rd /Add

NET USER Administrator activate:yes


Windows 10 – Offline Files not Available (Where did the Online Button Go ?)

October 4, 2017


In windows 7 using the file Explorer you could use a button to work back online, when you have been working offline.

Example after making a VPN connection to your home base, you could switch to work back “online” for all offline files and folders.


In Windows 10, this feature seem to have disappeared ?

But not realy ….


Solution :

Once you are offline, first connect back using a VPN connection to your server….

And in the File Explorer go to EASY ACCESS  next click work OFFLINE ?

This is the confusing part… even if you are working offline you need to click  work offline again, to go ONLINE ?  Smile



You can monitor the status bar of the file eplorer at the bottom it should change to ONLINE.


The funny part is that the label of the Button “Work Offline” will never change to Work ONLINE Confused smile

If this does not work in your case you can try to add this Registry Key, reboot and try again….

Add : SilentForcedAutoReconnect : REG_DWORD = 1


It did work in my case Smile


Enjoy !!

Windows Core IoT – Remote access on a Raspberry PI3

October 1, 2017

This is the procedure to configure remote access to Windows IoT on a RPI3


1. First Activate the REMOTE Access on your RPI3

Open connection to your RPI3 using the Web Portal,

and go to REMOTE to active Remote Access



2. Next install the Remote Display App from the App Store on your Windows 10 PC


After Download you can start the App to connect to your RPI3