Forum Discussion

eiashken's avatar
eiashken
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

cosmosdb in PowerBI SQL Statement

I have been trying to add an SQL statement during CosmosDB connection to save time and performance in aggregation. I got an error that says that I have an error in my errors table.. But the query ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi eiashken ，

 

What is the error you are getting?In which connection mode do you choose before connecting to CosmosDB?"Import "or "Directquery"?

 

Best Regards,

Kelly

  • eiashken's avatar
    eiashken
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    Where can I choose these options?

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi eiashken ，

       

      Try the following steps to do the troubleshooting:

       

      1.If you dont add the statement, is it available to connect the data source?

      2.Have you installed  Cosmos DB ODBC driver?Are you using ODBC Connector in desktop such as below?

       For references,pls click here.

       

       
       
      Do check all the questions above,if there still has some errors ,pls advise me what the error you are getting?
       
      Best Regards,
      Kelly