Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Duplicate Data Source error for brand new, virgin report

Hi everyone,    We have a PBI implementation in our company with Enterprise Gateway installed on-prem installed on our servers and we have been actively ustilisng on-prem data in the PBI Cloud, by ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Apparently this is a bug as per this post. Closing this post for now.

     

    Thanks

    Kaz

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

I make a test when adding data source using the following URL , I get same error message as yours. However, if I remove the "&rs:Command=Render&rs:Format=CSV" part from the URL, I can succssfully add the data source.

http://reportingservices/ReportServer/Report/?/Report%20Builder%20Reports/Information%20Technology/Power%20BI%20Data%20Sources/Service%20Desk/Jira%20Tickets%20Data&rs:Command=Render&rs:Format=CSV

Please directly enter the following URL when adding data source. You can test it when moving your SSRS report to your original folder and deleting the existing data source.

http://reportingservices/ReportServer/Report/?/Report%20Builder%20Reports/Information%20Technology/Power%20BI%20Data%20Sources/Service%20Desk/Jira%20Tickets%20Data


Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous

 

I have got other reports that are working perfectly with the query string parameters for causing the SSRS engine to ouput the result as CSV, so not sure why it's not working in this case. And, from memory, I don't think the output of the pure SSRS URL(without rs:Command &rs:Format query string paramters) is usable in Power BI, as at the time of our testing, it was giving a blank HTML document, if I remember correctly. 

 

Thanks 
Kaz