# Creating embed token for accessing dataset

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FE46i538tWYZW96WvStgM%2FErro.png?alt=media&#x26;token=4c53ca6b-2bcc-447e-8a8e-c31a74eb6418" alt=""><figcaption></figcaption></figure>

#### Passo 1: Conectar ao Servidor via SSMS

**1.1. Obter o Server Name**

1. Acesse o **Azure Portal**.
2. Vá até o recurso **Azure Analysis Services**.
3. No menu **Overview**, copie o **Server Name**.

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FXsEnV5Un25TsSylhVvgw%2FAAS%20-%20Azure.png?alt=media&#x26;token=5be718f5-2317-4b56-b244-408bf106ce24" alt=""><figcaption></figcaption></figure>

**1.2. Conectar no SSMS**

1. Abra o **SQL Server Management Studio (SSMS)**.
2. Clique em **Conectar** e selecione a opção **Analysis Services**.

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FE0GfhTSRUEcYHdNHrE8U%2FSSMS%20-%20Conect.png?alt=media&#x26;token=28dbf5d0-123d-4260-9190-94d5cab623e1" alt=""><figcaption></figcaption></figure>

3. No campo **Server Name**, cole o valor copiado anteriormente, Insira suas credenciais no campo **Username** e clique em **Conectar**.

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FQppumKPQYbnlgawRXuOR%2FServer%20name.png?alt=media&#x26;token=cc4a9131-7e36-4fd5-bb13-b6159fafa898" alt=""><figcaption></figcaption></figure>

**1.3. Adicionar o Service Principal**

1. Após a conexão, clique com o botão direito sobre o servidor e selecione **Propriedades**.

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FY8Qz39x3w4X6nDBvVqaS%2FProperties.png?alt=media&#x26;token=2ed194b1-ef3e-498f-a981-cc27029f420c" alt=""><figcaption></figcaption></figure>

2. Na nova janela, vá até a guia **Segurança e** Clique em **Add** para adicionar um **Service Principal**.

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FtVlscKipUw5eoYidXNA0%2Fsecurity.png?alt=media&#x26;token=9bbd4cd5-50e2-498a-901d-329adf50f16d" alt=""><figcaption></figcaption></figure>

3. Em **Manual Entry**, insira o service principal no seguinte formato:  app:AppicationClientID\@DirectoryTenantID

<figure><img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FTQAMq6HFWd7Q41KLg2xn%2FManual%20entry.png?alt=media&#x26;token=0508c8bc-bf06-4ef6-9a75-cf798d0b944a" alt=""><figcaption></figcaption></figure>

<details>

<summary>Passo 2: Obter o Application Client ID e Directory Tenant ID</summary>

* No **Azure Portal**, acesse **Microsoft Entra ID**.

<img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FwwvLcY6gJ1RzaZjcJq0L%2Fimage.png?alt=media&#x26;token=ff534fd3-aabe-41a5-b3fe-37a2d4e51ffa" alt="" data-size="original"><br>

* No menu lateral, clique em **App Registrations** (Registro de Aplicativos) e busque pelo **service principal** criado durante a instalação do portal (por padrão, o nome é **PowerEmbedded-app**).

<img src="https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2Fz45uf6OXHxqxPi7QRNS9%2FAPP%20Registration.png?alt=media&#x26;token=52aa5b83-3831-4428-b922-5ca87a953d00" alt="" data-size="original">

* Copie os seguintes valores:
  * **Application Client ID**
  * **Directory Tenant ID**

![](https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2Fqq4UVxhfYnU89q22T8xx%2Fimage.png?alt=media\&token=bd4df7fe-ee9e-459b-8f17-c1419b74d014)

* Monte a string no formato correto:

  ```
  App<ApplicationClientID>@<DirectoryTenantID>
  ```

  Exemplo:

  ```
  app:436fed95-c8bc-4e1a-92d7-99a52c353675@ec50c6a3-b95c-4f22-8424-318f1cd459c6
  ```
* Volte ao **SSMS**, cole esse valor no campo **Manual Entry** e clique em **Add**.

![](https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FYMvFPFU042p1H8mJeH30%2Fimage.png?alt=media\&token=770c8402-06ad-4a1e-a482-4b707b7f659d)<br>

* Confirme as alterações clicando em **OK**.

![](https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2FPWsJXtJeNzecUiAS7kz2%2Fimage.png?alt=media\&token=f3c76b14-a5f5-48f1-9593-07bcb93596d8)

</details>

Feito esse processo nós acabamos de adicionar o PowerEmbedded-app com administrador do Azure Analysis Service, o próximo passo é acessar o portal de administração do Power Embedded e clicar em salvar, siga o passo 3.

<details>

<summary>Passo 3: Acessar o portal do Power Embedded<br></summary>

* Acesse o **Portal de Administração do Power Embedded e** vá até **Configurações** e clique no botão de salvar.&#x20;

![](https://2938845060-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2gQSHbraGsYbDGTmWAa%2Fuploads%2Fx9IsmbInMb7Sddi5Dw7R%2Fimage.png?alt=media\&token=58cc10a8-22d4-4acd-81e2-4244045d1115)<br>

Feito isso os relatórios irão funcionar normalmente

</details>