Data Source Prerequisites Power Query. From the Navigator dialog box you can either transform the data in the Power Query editor by selecting Transform Data or load the data by selecting Load. A new window will appear where you can change your data source for ALL of your queries.
2 minutes to read. And pass to. In Power Query Editor Select Home Recent Sources.
Select Data Get Data Launch Power Query Editor.
In the ribbon select the Options button and. Let QryParam TableFirstValueExcelCurrentWorkbookNamemyURLContent Source WebPageWebContentsQryParam Data0 Source0Data in Data0. 11 Zeilen Power BI data source prerequisites. In Power Query in Excel click Get Data - From File - From Sharepoint Folder.