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 ...
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

    • Rishabh_THB's avatar
      Rishabh_THB
      Frequent Visitor
      9 years ago


      In response to the answer to my third query, Whether the refreshment of data will start automatically once the connection is back or whether the powerBi will miss that particular scheduled refreshment timing (due to loss in connection during the refreshment time) and will refresh datas to upcoming scheduled timings?
      For example: I have set my refresment timings to 6:00 pm and 10 pm and during 6 pm my connection got lost. And lets say the connection is back at 8:00 pm. Now will the powerbi first do the data refreshment corresponding to 6 pm timings and then do the 10 pm refreshment or will it skip the 6pm refreshment timing and will only respond to the upcoming timing, which is 10 pm.  

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Rishabh_THB,

        What refresh frequency do you set? Power BI will respond to the upcoming timing.

        Thanks,
        Lydia Zhang