Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Needs Info

Power BI Dataset connection to aurora db

Power BI Desktop connected to the Aurora Database and I created a report based on imported dataset and published the report.
Now I am trying to directly connect to the Data Source using the credentials but its stuck at loding screen after clicking sign in.

Please help out how to resolve this. Aurora DB is publicly accessible.

3 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    Aurora Database ? I didn't find this data connector in PBI Desktop . You also mentioned "You created a report based on imported dataset" , so what is the data source you connect to ? Can you explain it in detail ? Or you can provide a screenshot of your connection information in Desktop.

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,
    I will describe the process for your understanding.
    I created Aurora sql RDS with end points. I went To Power BI Desktop -> Get Data -> My Sql Database -> server gets the aurora database instance endpoints and then the database name - > Next we give the credentials and then import data. 
    Created a report with the imported data and published it.
    On the Power BI service -> Dataset settings -> data source credentials -> after the credentials are given sign in.

    Then we are stuck on the screenshot shared in the issue area.

  • Olá bom dia, meu relatorio está dando um problema qundo tento fazer a publicação dele ne web, aparece uma mensagem dizendo erro ao renderizar o relatorio  e diz que o seguinte erro required property `workspace` not found in JSON ´´ line 1, position 37.  Porém se eu sair e entra no relatorio ele publica, porém se eu tentar entrar em outra conta para publicar ele dá o memo erro dnv.