Connect to Spaceparts dataset using Tabular Editor 3

It seems like you're encountering an issue connecting to the Spaceparts dataset using Tabular Editor 3. The error message you've mentioned is not provided, but I can provide you with general guidance on how to connect to a data model using Tabular Editor 3.

Before you begin, make sure you have the necessary permissions to access the SQL Server database at the provided endpoint.

Here are the general steps to connect to a data model using Tabular Editor 3:

1. Open Tabular Editor 3:

   • Launch Tabular Editor 3 on your computer.

2. Connect to Database:

   • In the top menu, click on "File" and then select "Connect to Database."

3. Specify Connection Details:

   • In the "Connect to Database" dialog, enter the necessary connection details:
     • Server: te3-training-eu.database.windows.net
     • Authentication: Choose the appropriate authentication method (Windows or Database).
     • Database: Specify the database name.

4. Connect and Load Model:

   • Click the "Connect" button to establish a connection to the database.
   • If the connection is successful, you should see a list of available databases.
   • Select the Spaceparts dataset or the specific database you are working with.

5. Load Data Model:

   • Once connected, you can load the data model by selecting the appropriate option. This may involve selecting a specific Analysis Services (Tabular) database or model.

6. Handle Errors:

   • If you encounter any errors during the connection or loading process, carefully review the error message for more information. It may provide insights into what went wrong.

7. Check Permissions:

   • Ensure that your account has the necessary permissions to access the specified SQL Server database.

8. Troubleshooting:

   • If you encounter specific error messages, you may want to search for solutions in the Tabular Editor documentation, forums, or community discussions.

If you provide more details about the specific error message you are encountering, I can offer more targeted assistance. Additionally, check for any updates to Tabular Editor 3, as newer versions may address bugs or compatibility issues.

Hi, 

I'm trying to connect to the SpaceParts database from PowerBI desktop. Following along with https://elearning.easygenerator.com/629114d6-0048-462f-b350-4b72671c3e1e/#/sections/2cb805f5ecf34098ad8346ff2ca8b9a5/questions/e6d44281563645e18ecabe83a1c6b40a

This is how I filled in the first pop up:

Using the given username and password does not seem to work:

1. Get Data from SQL in Power BI
server: te3-training-eu.database.windows.net
username: dwreader
password: TE3#reader!

2. Save file as .pbip 

3. Load .pbip in Tabular Editor

For those of us still struggling to get the SpaceParts semantic model work!

Download the PBIT from here: https://tabulareditor.com/hubfs/SpaceParts%20sample%20files%20and%20starter%20kits.zip

Extract the downloaded zip file, then extract the spaceparts.zip. Inside you'll find SpaceParts.pbit

Open the PBIT and use the following parameters:

• SqlEndpoint: te3-training-eu.database.windows.net
• Database: SpacePartsCoDW
• RangeStart: 1/1/2024
• RangeEnd: 1/1/2025

When asked for authentication, switch to Database and use the following credentials

• User name: dwreader
• Password: TE3#reader!

Read the details about the semantic model here: https://tabulareditor.com/blog/reintroducing-the-spaceparts-dataset

Remember, it is against the license terms to use this dataset for commercial purposes. This includes providing training, creating advertising or demos for commercial products or services, and testing or developing these commercial products and services.

Hit Kudos if this helped you!!