Forum Discussion
Semantic model uses default data connection - semantic model connecting to data warehouse
torishriver To fix this error just follow the below steps
1. Go to Dataset -> Settings
2. Under the Settings you can find Gateway and Cloud Connections
3. Click Create Connection
4. Under here you have to create a new connection and provide your SQL Server string and your credentials, authenticate it and click Create (located at the bottom)
5. Once created go back to your dataset settings and under Gateway and Cloud Connections choose"New_Connect" (in my case)
6. Now you should be able to refresh the model
Thanks,
Jai
torishriver To fix this error just follow the below steps
1. Go to Dataset -> Settings
2. Under the Settings you can find Gateway and Cloud Connections
3. Click Create Connection
4. Under here you have to create a new connection and provide your SQL Server string and your credentials, authenticate it and click Create (located at the bottom)
5. Once created go back to your dataset settings and under Gateway and Cloud Connections choose"New_Connect" (in my case)
6. Now you should be able to refresh the model
Thanks,
Jai
That seems to have worked but I'm now receiving this error-- do you have any idea what to do to fix this? I can't tell if it's having a problem with none vs organizational privacy levels but it's failing to refresh regardless of which privacy level I set the gateway to:
Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface.