This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 27%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
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