Forum Discussion

blackhall8's avatar
blackhall8
Frequent Visitor
7 years ago
Solved

Datasource can't connect in Report Server

I've created a query in our CRM that outputs the prospect ID for each lead. The JSON query URL is public and accessible via this link: https://admissions.som.yale.edu/manage/query/run?id=04b3e32f-cd8...
Help me please
Report Server
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi blackhall8 

    I have used your url and created a Power BI file and saved to the Power BI Report Server Succesfully.

    I tried to add a data source and I received a similar error as the one you received. This did not deter me as I have noticed that this has occurred before with other odata connections I have. I then created a scheduled refresh and ran it. Completed Data Refresh was the result. Can you give it a try and see if it works for you.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi blackhall8 

I have used your url and created a Power BI file and saved to the Power BI Report Server Succesfully.

I tried to add a data source and I received a similar error as the one you received. This did not deter me as I have noticed that this has occurred before with other odata connections I have. I then created a scheduled refresh and ran it. Completed Data Refresh was the result. Can you give it a try and see if it works for you.

 

blackhall8's avatar
blackhall8
Frequent Visitor
7 years ago

Anonymous - You are absolutely right! Despit the test connection not working, the scheduled data refresh worked fine and the "Completed Data Refresh" was the result. Thank you!