We have two different data sources available to consume by Power BI. These contains the same data.
1. SQL Server relational data source
2. Analysis Services - Cube
I have created separated .pbix files by making Live connections to each data source separtely. I found some differences in the .pbix file which was connected to Analysis services.
1. Relationship tab is not visible
2. Cannot create new column
3. Initially when making the connection to analysis services, it did not give the Import option
As i am new to Analysis services, please confirm if above differences are expected. And also if there is any guide which explains these differences.