The SQL Pool doesn't have a sample database.

Bezerra, Itajiba 6

The https://learn.microsoft.com/en-us/training/modules/build-reports-using-power-bi-azure-synapse-analytics/, Unit 6 (Exercise - Create a new Power BI report in Synapse Studio), step 3, the query returns an error: 0:58:22 AM Started executing query at Line 1 Invalid object name 'wwi.SaleSmall'. Total execution time: 00:00:00.697 The step 5, no table is listed. synapse1

synapse2

Abi 170 Reputation points

2024-01-16T15:10:20.38+00:00

Hi Bezerra, Itajiba, As mentioned Serverless SQL pool does not have any tables. You mean Synapse dedicated SQL pool table? If yes, its same as normal SQL server. use SQL authentication and user your dedicated SQL pool server name and database name along with SQL credentials. You can get synapse dedicated SQL Pool server name on overview page and SQL authentication information you can get from SQL Admin User Name from properties.
Below link helps to understand administrative accounts in Synapse SQL.
Administrative accounts in Synapse SQL in Azure Synapse Analytics Hope this helps. Please let us know if any further queries.

2 answers

Bezerra, Itajiba 6 Reputation points

2024-01-16T17:35:31.9166667+00:00

Hi Abi, Thanks for your attention. However, why does the exercise in the https://learn.microsoft.com/en-us/training/modules/build-reports-using-power-bi-azure-synapse-analytics/ seem the database is already existed ? Is it a mistake in the training? Warm regards, Itajiba
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Bezerra, Itajiba 6 Reputation points

2024-01-16T17:40:37.0933333+00:00

I have found the database: https://github.com/microsoft/MCW-Azure-Synapse-Analytics-and-AI/blob/main/Hands-on%20lab/HOL%20step-by%20step%20-%20Azure%20Synapse%20Analytics%20and%20AI.md
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer