Write
280
edits
m (Ash moved page Linking your data to a Standard Microsoft Power BI Report to Linking your Odata Feed to a OdataLink Standard PowerBI Report Template: changes suggested by Jeff - Keywords OdataLink, report, template) |
m (Added image to highlight using consolidation OData feed rather than company feed for report templates) |
||
Line 1: | Line 1: | ||
[[File:copy_consolidation_odata_feed.png|300px|thumb|right|Copy the Consolidation OData Feed]] | |||
[[File:PowerBI_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | [[File:PowerBI_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | ||
OdataLink provides a set of free downloadable Power BI Report templates which are | OdataLink provides a set of free downloadable Power BI Report templates which are linked to [[OData Feed URLs | OData Feeds]] of a demo company file. | ||
In order to replace the existing demo company data with your data in the report, replace the existing OData feed as a Data Source to your own [[OData Feed URLs|OData feed url]]. | |||
The following guide will assist in linking your data to the report template. | |||
= Steps = | = Steps = | ||
Line 14: | Line 13: | ||
[[File:PowerBI_ODataFeed_URL.png|300px|thumb|right|Paste the copied OData feed url]] | [[File:PowerBI_ODataFeed_URL.png|300px|thumb|right|Paste the copied OData feed url]] | ||
To link your OData feed | To link your company OData feed with OdataLink standard report template, follow these steps. | ||
Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | Before beginning, ensure you have [[Copying the OData feed URL|copied the Consolidation OData Feed URL]], highlighted in the first image. | ||
# | # Open '''Microsoft Power BI desktop''', click on '''File''', select '''Options and Settings''' and then '''Data Source Settings'''. | ||
# In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Change Source'''. | # In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Change Source'''. | ||
# In the next dialogue, paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | # In the next dialogue, paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | ||
# The report would refresh and download your company data into the report. | |||