Forum Discussion

Rishabh_THB's avatar
Rishabh_THB
Frequent Visitor
9 years ago
Solved

integration with live source

i am currently using a powerbi pro trial account. i want to make a report through an sql server. Now once i have made the report and published it to have and after that scheduled a refresh, how will powerbi do the refresh action? Would it consume live data direclty from my sql server data source and then update my report or will it first download the data from the data source and then integrate that data with the report? 

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Rishabh_THB，

    Firstly, it is possible that a you get quick real time data from the source. You would need to use streaming dataset, and create real-time dashboard, for more details, please check this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/

    Secondly, currently, Power BI still performs a complete refresh of the data each time it refreshes. What you describe is incremental refresh, this feature is not available in Power BI, an idea about this issue has been submitted in this link, please vote it up.

    Thirdly, refresh will fail when the connection is lost.

    Thanks,
    Lydia Zhang

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Rishabh_THB,

    Please open a new thread about the above new issue.

    Thanks,
    Lydia Zhang

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Rishabh_THB,

    Whenever you refresh data in a dataset, Power BI uses information in the dataset to connect to the data sources defined for it, query for updated data, and then loads the updated data into the dataset.

    You can take a look at this article about how gateway works to refresh your dataset.


    Thanks,
    Lydia Zhang

    • Rishabh_THB's avatar
      Rishabh_THB
      Frequent Visitor
      9 years ago

      Hello Lydia

       

      Thanks for a quick response. Just a few more questions.

      1.  Is it possible to run a live query on the data set in POWERBI while refreshing the data, so that instead of uploading the whole data again and again, we get a quick real time data from the source? 

       

      2.  Is it possible for PowerBI to append data to an existing model instead of refreshing or reloading the data completely. 

       

      3.  What will happend if someone the connection gets lost in the middle of data refreshment?


      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Rishabh_THB，

        Firstly, it is possible that a you get quick real time data from the source. You would need to use streaming dataset, and create real-time dashboard, for more details, please check this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/

        Secondly, currently, Power BI still performs a complete refresh of the data each time it refreshes. What you describe is incremental refresh, this feature is not available in Power BI, an idea about this issue has been submitted in this link, please vote it up.

        Thirdly, refresh will fail when the connection is lost.

        Thanks,
        Lydia Zhang