FIX: The account URL shouldn’t have query parameters or path parts

Unable to connect?

If you create a PowerShell script, or perhaps another script that you use to create an output that is then stored in a storage, you do not want to display this output in a .CSV file, but in a tool such as Microsoft PowerBI. Do you recognize this?

Then you probably recognize that you do not work often enough with PowerBI and therefore always encounter the same error messages.

The error message “The account URL should not have query parameters or path parts” is one of them.

Unable to connect: The account URL shouldn't have query parameters or path parts.
Unable to connect: The account URL shouldn’t have query parameters or path parts.

Well, let me explain this to you.

I almost always write the data to Azure Storage when I use PowerBI. Here you can request the URL to an Azure Storage Table.
So let’s take as an example this is the URL I use:

https://baswijdenes2019.table.core.windows.net/BWITblog

The URL seems pretty straight forward to me, but unfortunately it doesn’t work.

The error message actually gives the solution, but you have to understand that.

The URL cannot contain query parameters or path parts.

The last part after the / is a path part. You can therefore delete this and you will be given the choice when configuring which table, you want to use.

So, the URL for me is:

https://baswijdenes2019.table.core.windows.net/

You can now continue with your Access Key.

Maybe it’s good to read the new blog post right away? since you encounter this, I expect that you will also encounter the following problem with showing the content in PowerBI.


The complete error message.

The complete error message for if someone searches on a different part.

“Unable to connect

We encountered an error while trying to connect.

Details: “The account URL shouldn’t have a query parameters or path paths”

Unable to connect: The account URL shouldn't have query parameters or path parts.
Unable to connect: The account URL shouldn’t have query parameters or path parts.

Published by

Bas Wijdenes

My name is Bas Wijdenes and I work as a PowerShell DevOps Engineer. In my spare time I write about interesting stuff that I encounter during my work.

Leave a Reply

Your email address will not be published. Required fields are marked *