In server already SQL Server 2017 Enterprise Core Edition is installed.
Also SSRS express edition is installed. While configguring the SSRS getting beow error.d be the cause?
Cannot create a connection to data source 'Mydatasource'. The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database" is not supported in this edition of Reporting Services.
When i want to install newly SSRS again its asking me to dopwnload from microsoft and only 3 of them available (express,evaluation and developer edition)
Anyone please suggest me what i need to do? which SSRS edition i need to install when SQL Core enterprise edition is installed?
What is the difference between enterprise and enterprise core edition?
Also i need to install power BI in same server and later i need to integrate both SSRS and POWER BI.. How to do that?
Do i need to configure SSRS and power bi seperately? or any other procedure to configure and integrate both at once?
It is little urgent.Please suggest how to proceed?