Forum Discussion

torishriver's avatar
torishriver
Advocate I
10 months ago
Solved

Semantic model uses default data connection - semantic model connecting to data warehouse

I have a semantic model in Power BI that I want to add a table to from a data warehouse. It refreshes on my desktop just fine, but when I publish it to the online version it gives me this error:   ...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    10 months ago

    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

v-hashadapu's avatar
v-hashadapu
Community Support
10 months ago

Hi torishriver , Thank you for reaching out to the Microsoft Community Forum.

 

We find the answer shared by Jai-Rathinavel  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you Jai-Rathinavel  for your valuable response.