Skip to main content

New data source and gateway management experience

Recently replaced the “manage gateway” experience with a new interface, making it easier to manage your gateways and data sources. With this new experience, you also get the ability to manage and create the Vnet gateway and use the recently released additional security roles.

How to create new data sources

  1. Navigate to powerbi.com
  2. Navigate to the Manage gateways page
  3. To create a new data source, click on the New button in the top ribbon
  4. Select the gateway you want to create a data source for and give the data source a name
  5. Select the Data source type. In this example we are using SQL
  6. Add the Server and Database and fill out the credentials
  7. Click on Create to create the data source. On success you see a message that the data source was created successfully
  8. Optionally, you can also set Single Sign-On for specific data sources and the Privacy level

How to view/change setting of data sources

  1. Select one of the data sources you want to view/change setting by clicking on the data source from the table
  2. From the top ribbon, click on Settings
  3. If you are an owner of the data source, you can update credentials. If you are a user of the data source, you only have read access

How to manage users for data sources

  1. Select one of the data sources you want to view/change setting by clicking on the data source from the table
  2. From the top ribbon, click on Manage Users
  3. From here you can manage who can use the data source

 

How to manage the gateway

  1. Navigate to the On-premises data gateway tab
  2. Select a gateway by clicking on the gateway in the table
  3. In the top ribbon you see multiple actions for the gateway
  4. To see the details of the gateway and to control if the gateway is enabled, click the details button
  5. To manage settings of the gateway cluster, like contact information, how to distribute request in the cluster, allowing cloud data sources through the gateway and custom data connectors, click the settings
  6. To manage the security roles of the gateway, use the Manage Users button
  7. To remove the gateway, click on remove

Comments

Popular posts from this blog

SSRS INTERVIEW QUESTIONS

Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package