locked
Why M Query Not referencing the Blob connection name where as it is hard coding the URL RRS feed

  • Question

  •        

    I have used Blob Connection in my Azure analysis service. I have added a blob connection, But when i used M Query it is not taking the Query Connection reference instead it is hard coding the complete connection while designing from editor

    If you observe the connection string is hard coded in the M Query "https://apcocoaas.blob.core.windows.net/", How to make to this is not going to happen in M query where all M Qeries should refer and use Blob connection name "AzureBlobConnection" instead hard coded URL.

    ---- Datasource COnnection 
    "dataSources": [
              {
                "type": "structured",
                "name": "AzureBlobConnection",
                "connectionDetails": {
                  "protocol": "azure-blobs",
                  "address": {
                    "account": "apcocoaas",
                    "container": "apcoco",
                    "domain": "blob.core.windows.net"
                  },
                  "query": null,
                  "authentication": null
                },
                "credential": {
                  "AuthenticationKind": "Key",
                  "path": "https://apcocoaas.blob.core.windows.net/",
                  "kind": "AzureBlobs"
                }
              }


    M Query
     "partitions": [
                  {
                    "name": "Partition",
                    "dataView": "full",
                    "source": {
                      "type": "m",
                      "expression": [
                        "let",
                        "     Source = #\"AzureBlobConnection\",",
                        "    #\"ZDQ_GDS_GL_CAS_MATERIAL_MD csv\" =Source{[#\"Folder Path\"=\"https://apcocoaas.blob.core.windows.net/apcoco/\",Name=\"produced/Dimensions/ZDQ_GDS_GL_CAS_MATERIAL_MD.csv\"]}[Content],",
                        "   #\"Imported CSV\" = Csv.Document(#\"ZDQ_GDS_GL_CAS_MATERIAL_MD csv\",[Delimiter=\",\", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),",
                        "    #\"Changed Type\" = Table.TransformColumnTypes(#\"Imported CSV\",{{\"Column1\", type text}, {\"Column2\", type text}, {\"Column3\", type text}, {\"Column4\", type text}, {\"Column5\", type text}}),",
                        "    #\"Promoted Headers\" = Table.PromoteHeaders(#\"Changed Type\", [PromoteAllScalars=true])",
                        "in",
                        "    #\"Promoted Headers\""
                      ]
                    }
                  }
                ]
              },



    Saturday, April 4, 2020 6:27 AM

All replies

  • Hello Raju , 

    Thanks for the question . Can you please let us know as to where are you execute this query ?


    Thanks Himanshu

    Monday, April 6, 2020 10:36 PM
  • We have not received a response from you.  Are you still facing the issue?  If you found a solution, would you please share it here with the community?  Otherwise, let us know and we will continue to engage with you on the issue.

    Thanks Himanshu

    Tuesday, April 7, 2020 6:10 PM
  • Hello, 

    We have not received a response from you.  Are you still facing the issue?  If you found a solution, would you please share it here with the community?  Otherwise, let us know and we will continue to engage with you on the issue.


    Thanks Himanshu

    Wednesday, April 8, 2020 8:31 PM