CODEWITHSUNDEEP
powerbi
Suraj Nath pandey
Suraj Nath pandey

Reputation: 29

how to insert data from sql server to power bi graph after publish on web

i am using power bi report in my project but i need my graph be change according to SQL server data. it means when we will insert new data in SQL server it effect my graph.

Upvotes: 1

Views: 144

Answers (2)

LuFFy
LuFFy

Reputation: 9297

Microsoft has already given the Documentation regarding it.

SQL Server Analysis Services live data in Power BI

In Power BI, there are two ways you can connect to a live SQL Server Analysis Services server. In Get data, you can connect to a SQL Server Analysis Services server, or you can connect to a Power BI Desktop file, or Excel workbook, that already connects to an Analysis Services server.

Important :

  • In order to connect to a live Analysis Services server, an On-premises Data Gateway must be installed and configured by an administrator. For more information, see On-premises Data Gateway.

  • When you use the gateway, your data remains on-premises. The reports you create based on that data are saved in the Power BI service.

  • Q&A natural language querying is in preview for Analysis Services live connections.

To connect to a model from Get data

  1. In My Workspace, select Get data. You can also change to a group workspace, if one is available.

enter image description here

  1. Select Databases & More.

enter image description here

  1. Select SQL Server Analysis Services > Connect.

enter image description here

  1. Select a server. If you don't see any servers listed here, it means either a gateway, and data source, are not configured, or your account is not listed in the Users tab of the data source, in the gateway. Check with your adminsitrator.

  2. Select the model you want to connect to. This could be either Tabular or Multidimensional.

After you connect to the model, it will appear in your Power BI site in My Workspace/Datasets. If you were swtiched to a group workspace, then the dataset will appear within the group.

enter image description here

Upvotes: -1

teylyn
teylyn

Reputation: 35945

You can use the on-premises Gateway to refresh data in a published Power BI data set with on-premise data like SQL Server data. Take a look at https://powerbi.microsoft.com/en-us/gateway/

The gateway is free, there is a personal and an enterprise flavor and it should run on a machine that is always on, so you can schedule data refresh to occur automatically.

Upvotes: 2

Related Questions