Power BI Exchange

Expand all | Collapse all

Scheduled Refresh in Power BI

  • 1.  Scheduled Refresh in Power BI

    Posted 5 days ago

    Hello All

    I have a Power BI report with a sales data set that is loaded from Azure SQL database (import) and make visualizations and dashboards. 

    Now what I want? if I get a new csv file with updated records of sales and can load it from Azure Blob storage

    --- Can I integrate the new records into existing power BI report (originally generated from Azure SQL database)

    --- if not what is the process to schedule refresh the sales data each day new file was loaded to blob storage with new sales records? 

    --- and how the scheduled refresh can undergo all data transformations that are saved in Power Query? 

    Thank you in advance for your help 

    Fraz



    ------------------------------
    Fraz Anjum
    ------------------------------


  • 2.  RE: Scheduled Refresh in Power BI

    Posted 5 days ago
    In PowerBI you can create a model with data from different data sources.
    Do you have to add data from csv file to data from Azure SQL or update data from Azure SQL with from csv file ones?
    You have to manage all the stuff (append, merge, or other more complex loading rules) in PowerQuery queries.
    Every time you will refresh your report all queries steps will be appllied to data.

    ------------------------------
    Lorenzo Vercellati
    Business Intelligence Senior Developer
    SolidQ
    Milan
    3382819866
    ------------------------------



  • 3.  RE: Scheduled Refresh in Power BI

    Posted 2 days ago
    Thank you very much Lorenzo!

    ------------------------------
    Fraz Anjum
    ------------------------------



  • 4.  RE: Scheduled Refresh in Power BI

    Posted 3 days ago
    Hi Fraz,

    Yes, you can do this. In Power BI, you would add the csv files using Get Data>Text/CSV which will open the file in Power Query. This will be a new query, separate from your query using Azure SQL. You can then Merge Queries or Append Queries to combine both of the data sources into a single table.

    Hope this helps.

    Mike

    ------------------------------
    Mike Hammons
    Director, Business Intelligence
    AKA Enterprise Solutions
    ------------------------------



  • 5.  RE: Scheduled Refresh in Power BI

    Posted 2 days ago
    Thank you very much Mike!

    ------------------------------
    Fraz Anjum
    ------------------------------