I am trying to create a Report Data Source to connect a traditional relational database for reporting. The connection is successful but when I try to create a Power View report, it gives me an error
"The current action cannot be completed. The data extension type for data source 'http://myserver/Shared Documents/AdventureWorksDW.rsds' is not valid for this operation."
My query is, whether it is possible to create a power view erport connecting to a relational database rather than an analysis server database? if yes, what mistake am I making?