Difference between revisions of "Connecting external Financial Statements to OdataLink"
Jump to navigation
Jump to search
m |
m |
||
| Line 4: | Line 4: | ||
These statements can be downloaded manually or automated to update frequently. | These statements can be downloaded manually or automated to update frequently. | ||
< | <div style="float:right"><ul> | ||
[[File:get_data_sharepoint.png|300px|thumb|right]] | <li style="display: inline-block;"> [[File:get_data_sharepoint.png|300px|thumb|right]] </li> | ||
[[File: | <li style="display: inline-block;"> [[File:get_data_sharepoint.png|300px|thumb|right]] </li> | ||
[[File:excel_login_sharepoint.png|300px|thumb|right]] | <li style="display: inline-block;"> [[File:excel_login_sharepoint.png|300px|thumb|right]] </li> | ||
[[File:pbi_login_sharepoint.png|300px|thumb|right] | <li style="display: inline-block;"> [[File:pbi_login_sharepoint.png|300px|thumb|right] </li> | ||
[[File:transform_data.png|300px|thumb|right] | <li style="display: inline-block;"> [[File:transform_data.png|300px|thumb|right] </li> | ||
[[File:select_tables_Power_query_editor.png|150px|thumb|right]] | <li style="display: inline-block;"> [[File:select_tables_Power_query_editor.png|150px|thumb|right]] </li> | ||
< | </ul></div> | ||
== Import Data from SharePoint == | == Import Data from SharePoint == | ||
Revision as of 01:05, 8 October 2024
Overview
Financial statements such as recurring Bank statements can be essential to improve insights within your reports.
These statements can be downloaded manually or automated to update frequently.
- To import data from SharePoint into Excel, go to Data > Get Data > From Other Sources > From Web.
- To import data from SharePoint into PowerBI, go to Get Data > More... > SharePoint Folder.
- Enter the URL to your SharePoint site.
- You may be asked to login to access data from SharePoint. Login using your Microsoft account / Organization account.
- Transform Data dialog box will open listing all the files in your SharePoint library. Click on Transform Data
- Locate the file and click on Binary.
- Transform the data accordingly and click on "Load".
- The data will be loaded to your Data Model.