Difference between revisions of "Linking your OData Feed to a OdataLink Standard PowerBI Report Template"

m
Added image to highlight using consolidation OData feed rather than company feed for report templates
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 created using an Odatafeed pointing to demo data file.
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.


Once you download a report, the downloaded report will contain the demo data.
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]].


In order to see your data in the report, you would need to replace the existing OData feed power query to your own [[OData Feed URLs|OData feed url]].
The following guide will assist in linking your data to the report template.  


The following guide will assist linking your data to the downloaded report.


= 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 power query in [[Microsoft Power BI]], follow these steps.
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.


# Within '''Microsoft Power BI desktop''', click on '''File''', select '''Options and Settings''' and then '''Data Source Settings'''.
# 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.




Write
280

edits