![power bi desktop connect to gateway power bi desktop connect to gateway](https://docs.microsoft.com/en-us/power-bi/connect-data/media/service-gateway-data-sources/remove-user.png)
![power bi desktop connect to gateway power bi desktop connect to gateway](https://blogs.sap.com/wp-content/uploads/2017/05/my_network_4.gif)
![power bi desktop connect to gateway power bi desktop connect to gateway](https://xenit.se/app/uploads/topology-pbi.png)
Use Ctrl to choose columns that aren't adjacent. To choose more than one column, first select a column then hold down Shift, select additional adjacent columns, and then right-click a column header to change all selected columns. Just right-click the column header, and select Change Type > Whole Number to change them. Here’s what that looks like.Īll those scores are text rather than numbers, and we need them to be numbers. If it's not, select View from the ribbon, then Query Settings to display the Query Settings pane. Select Transform Data to load the table and launch Power Query Editor. The Navigator window displays a preview.Īt this point, you can edit the query before loading the table, by selecting Transform Data from the bottom of the window, or just load the table. We're interested in the table, so we select it from the list. In this case, it found a table and the overall Document. Power BI Desktop contacts the Web resource, and the Navigator window returns the results of what it found on that Web page. When you select OK, the Query functionality of Power BI Desktop goes to work. Or… perhaps you’re a data analyst, and you want that information to help your customers, as in, help your raincoat manufacturing client target sales where it rains a lot.Įither way, you find a Web resource that has interesting data about those topics, and more: You want to live where there’s lots of sunshine, preferable taxes, and good health care.
Power bi desktop connect to gateway how to#
The following image shows how to connect to data, by selecting Get data > Other > Web.įor this example, we'll connect to a Web data source. There are all sorts of data sources available in Power BI Desktop. If you don’t have Power BI Desktop, you can download and install it. With Power BI Desktop, you can easily connect to the ever expanding world of data.