Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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.

Subhro95_0-1673968525712.png

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

Status: Needs Info
Comments
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
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.

renanng
New Member

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.