Power pivot model to Analysis Service

  • Thread starter Thread starter shivam1450
  • Start date Start date
S

shivam1450

Guest

Hi,

I created a power pivot model using azure SQL database.I was able to get that model to open with visual studio and then change the compatibility level to 1500 So i could change the data source link from power query to SQL database for live connection of data. but when i try to deploy it i get following error:

Failed to save modifications to the server. Error returned: 'Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition.

Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition.
The 'Category' column does not exist in the rowset. how can i fix it?


Continue reading...
 
Back
Top