Connecting with connection string for Azure Storage Table

[Anonymous]

Hi!

I'm trying to connect an Azure Storage Table to PowerBI. From my Azure admin, I received a connection string with the following format:

https://<Account Name>.table.core.windows.net/?sv=<Some Date>&ss=t&srt=o&sp=rl&se=<Some DateTime>&st=<Another DateTime>&sip=<External IP address>&spr=https&sig=<Signature>

And a client needs to use this to connect with Power BI. For myself, I have a regular Account and Account Key, but the client is not allowed to use that one.

Is there any way to use this string in Power BI?

I've tried to enter the whole string in "= AzureStorage.Tables("https://<Account Name>.table.core.windows.net/

?sv=<Some Date>&ss=t&srt=o&sp=rl&se=<Some DateTime>&st=<Another DateTime>&sip=<External IP address>&spr=https&sig=<Signature>")" , with all actual values obviously, but then I get the following error:

"DataFormat.Error: The Account URL shouldn't have query parameters" and googling the error didn't help me.. Does anyone here have a solution?

Thanks!

Jeroen

[Anonymous]

@Anonymous,

When connecting to Azure Table Storage in Power BI Desktop, it requires Account name and Account key. 

In your scenario, when the client wants to reuse the connection string, the client should also provides a relevant account name and account key that has access to the Azure Table Storage. And to ensure the connection is correct, go to Advanced Editor of the successful query, copy all the code, then add a new blank query and paste the code to Advanced Editor of the blank query.

Regards,
Lydia

[Anonymous]

Okay so the problem is that the client doesn't manage the table storage. The azure admin at my company does, and he does not want to share the account name and account key with the client (which is fair). The client needs access to the table storage for reporting purposes, but should not be allowed to write or anything.

So the client does not have a account name/key.

Regards,

Jeroen

[Anonymous]

@Anonymous,

What operation does the client want to do? If he wants to create his own visualizations, consider to publish the PBIX file to Power BI Service, share the report to the client. Then the client can use Analyze in Excel feature to connect to the dataset in Excel, and create visuals in Excel.

Regards,
Lydia

[jimmcslim]

What you want is support in Power BI for accessing Azure Table Storage with Shared Access Signatures - these can be generated via the Azure Storage APIs to limit access to certain tables (or collections/blobs in the case of Blob Storage) for a certain period of time.

Unfortunately for you I suspect that Power BI doesn't currently support Shared Access Signatures. Yet another thing to be added to ideas.powerbi.com... (a few moments later) ... looks a request for this has already been made; go vote! https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9953427-connect-to-azure-tables-v...

Maybe create a second Azure Storage Account for this particular client and replicate data across using AzCopy?