{"id":6041,"date":"2022-09-14T08:30:20","date_gmt":"2022-09-14T08:30:20","guid":{"rendered":"https:\/\/www.stl-training.co.uk\/b\/?p=6041"},"modified":"2023-12-30T23:03:16","modified_gmt":"2023-12-30T23:03:16","slug":"update-power-bi-reports-using-connections-to-source-data","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/update-power-bi-reports-using-connections-to-source-data\/","title":{"rendered":"Update Power BI Reports using Connections to Source Data"},"content":{"rendered":"

\"Update<\/a><\/p>\n

Power BI<\/a> desktop can easily connect to an amazing range of different sources. This allows you to always keep your reports updated whenever you add new records or original data changes at source. It also helps you to be more efficient and productive and saves a lot of time in the process. This article shows how to update Power BI reports using connections to source data.<\/p>\n

What is a Data Source Connection and why is it useful?<\/h5>\n

Whenever you tell Power BI Desktop to \u2018Get Data\u2019, what you are doing is making a connection to the source data<\/a>. Let\u2019s say you had a monthly table in Excel detailing all the records for each order in June. You first connect to this Excel file in Power BI Desktop, load the data, then create your report visuals from this imported data. Once someone adds <\/span>July\u2019s orders\u00a0 at source, a simple \u2018Refresh\u2019 in Power BI Desktop will update the report to reflect the changes you have made. This avoids having to re-import your updated data every time it changes.<\/span><\/p>\n

How to get started<\/h5>\n
    \n
  1. In the REPORT view of Power BI Desktop, go to HOME > GET DATA<\/li>\n<\/ol>\n

    \"\"<\/a><\/p>\n

    2. Select \u2018Excel Workbook\u2019 from the top of the list and browse to your Excel file<\/p>\n

    3. This action brings up the following:<\/p>\n

    \"\"<\/a><\/p>\n

    4. Select \u2018FoodSales\u2019, for example, by ticking the box. Note this gives a preview of the data selected<\/p>\n

    5. Click on the LOAD button below<\/p>\n

    This will make a connection back to the source data. This means any new data added to the source is instantly refreshable in the report<\/p>\n

    6. Go to the DATA view to see how many total orders there are:<\/p>\n

    \"\"<\/a><\/p>\n

    From the \u2018Order ID\u2019 field highlighted, there are 1,149 orders in total<\/p>\n

    7. Go back to the Report View and select the ‘Card\u2019 icon from the Visualisations pane<\/p>\n

    \"\"<\/a><\/p>\n

    8. Click on the \u2018Order ID\u2019 field from the \u2018Fields\u2019 pane to show the total number of orders i.e. 1149 in the Card visual<\/p>\n

    9. Create another Card visual and drop the \u2018Extended Price\u2019 field inside to show \u2018Total Extended Price\u2019 i.e. 706.77K. The report should look like this:<\/p>\n

    \"\"<\/a><\/p>\n

    10. Save the report and then open the Excel file outside of Power BI Desktop<\/p>\n

    11. Copy and paste new records below the original dataset. Save and close the file<\/p>\n

    12. In Power BI Desktop, go to HOME > REFRESH to update your report<\/p>\n

    \"\"<\/a><\/p>\n

    Note that the 2 Cards have both updated to reflect the changes.<\/p>\n

    There are many other sources that Power BI Desktop can recognise e.g. online data, SQL, CSV, various databases, SharePoint. In all, there are around 60 different locations from which Power BI can \u2018Get Data\u2019. The great news is that they all use pretty much the same connection method as for Excel. Moreover, the vast choice in data sources gives you greater flexibility in being able to access your data wherever you store it.<\/p>\n

    Conclusion<\/h5>\n

    Power BI Desktop\u2019s ability to connect to many different data sources allows you to always keep on top of your latest figures in order to make those all-important business decisions and therefore become more productive. As you can see, then, it is quite easy to update Power BI reports using connections to source data.<\/p>\n

    For course details on the Power BI Reporting course at STL, please click on the link below:<\/p>\n

    https:\/\/www.stl-training.co.uk\/syl\/355\/power-bi-training-courses.html<\/a><\/p>\n

    To see more articles on data connections, please click below:<\/p>\n

    Power BI Connections | List of Top 6 Data Connection Source Categories (wallstreetmojo.com)<\/a><\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Power BI desktop can easily connect to an amazing range of different sources. This allows you to always keep your reports updated whenever you add new records or original data changes at source. It also helps you to be more efficient and productive and saves a lot of time in the process. This article shows […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[637,650],"tags":[],"class_list":["post-6041","post","type-post","status-publish","format-standard","hentry","category-application","category-power-bi"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/6041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=6041"}],"version-history":[{"count":4,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/6041\/revisions"}],"predecessor-version":[{"id":6053,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/6041\/revisions\/6053"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=6041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=6041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=6041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}