Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Connecting with connection string for Azure Storage Table

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • jimmcslim's avatar
        jimmcslim
        Helper III
        8 years ago

        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-via-shared-access-signatur

         

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