Write
280
edits
Difference between revisions of "Connecting external Financial Statements to OdataLink"
Connecting external Financial Statements to OdataLink (view source)
Revision as of 00:33, 8 October 2024
, 8 Octoberno edit summary
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. | ||
[[File:get_data_sharepoint.png|right| | [[File:get_data_sharepoint.png|right|250px|]] | ||
[[File: | [[File:get_data_sharepoint_excel.png|right|250px|]] | ||
[[File:excel_login_sharepoint.png|right| | [[File:excel_login_sharepoint.png|right|250px|]] | ||
[[File:Pbi login sharepoint.png|right| | [[File:Pbi login sharepoint.png|right|250px|]] | ||
[[File:transform_data.png|right| | [[File:transform_data.png|right|250px|]] | ||
</gallery></div> | |||
</div> | |||
<br \> | |||
== Import Data from SharePoint == | == Import Data from SharePoint == | ||
| Line 19: | Line 20: | ||
# You may be asked to login to access data from SharePoint. Login using your Microsoft account / Organization account. | # 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''' | # 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'''. | # '''Power Query Editor''' Dialog box will appear. Locate the file and click on '''Binary''' in the '''Content''' column. | ||
# Transform the data accordingly and click on "Load". | # Transform the data accordingly and click on "Load". | ||
# The data will be loaded to your Data Model. | # The data will be loaded to your Data Model. | ||