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

Rishabh_THB's avatar
Rishabh_THB
Frequent Visitor
9 years ago

Hello
I got the idea. Right now i'm facing another issue with data refresh. I have used DirectQuery to get data through sql server. I have also used on premises data gateway and connected my live server with it.

 

Now once i have made the report and scheduled a refresh of 30 min, i published the report to web. What i'm getting on the web page is an error with no visualization. Also the data doesn't get updated even after repeated automatic refresh and my online server on which i'm running the query has already updated the data and this new data was supposed to be visible in my report. 

Please help !!!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Rishabh_THB,

Please open a new thread about the above new issue.

Thanks,
Lydia Zhang