locked
Power Pivot data refresh in Office 365 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I have a Trial Power BI site on Office 365, on which I published an Excel 2013 Workbook with Power Pivot.

    The Data Source of the Power Pivot reads from an SQL Server Database. I want to schedule the refresh of this workbook, so I followed the steps of creating a Gateway and Data Source (took the exact connection string and provider type as defined in the Excel workbook). 

    Upon testing the Data Source, it succeeds and it's status is Ready. The Gateway's status is also Running.

    Upon refresh, it takes a long time to finish and send the below error:

    Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Unable to connect to the remote server;A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <IP>:443

    Any reference regarding the matter is appreciated.

    Thank You,

    Grace

    Friday, March 21, 2014 2:08 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Grace,

    Couple of questions:

    • Do you see a reference to the refresh on the Power BI Admin center under system health? that message can assist sometimes in understanding the fault (we are working on getting all, and better messages to the email as well)

    • In the definition of the data source you selected the option of connection string right? (not connection properties)
    • Are you getting this result when you are doing refresh now or only upon schedule?
    • We can further investigate if you provide us the correlation id to this address

    GALROY

    Friday, March 21, 2014 4:20 PM
    Moderator

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Grace,

    Couple of questions:

    • Do you see a reference to the refresh on the Power BI Admin center under system health? that message can assist sometimes in understanding the fault (we are working on getting all, and better messages to the email as well)

    • In the definition of the data source you selected the option of connection string right? (not connection properties)
    • Are you getting this result when you are doing refresh now or only upon schedule?
    • We can further investigate if you provide us the correlation id to this address

    GALROY

    Friday, March 21, 2014 4:20 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello Galroy,

    I submitted details to the address mentioned on the messages and correlation id.

    I tried both the scheduled and refresh now option.

    The Connection String was used and not the Connection Properties.

    Thanks,

    Grace

    Friday, March 21, 2014 4:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Galroy,

    I submitted details to the address mentioned on the messages and correlation id.

    I tried both the scheduled and refresh now option.

    The Connection String was used and not the Connection Properties.

    Thanks,

    Grace

    Grace, is this still an issue?

    Thanks!

    Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Thursday, April 10, 2014 12:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    It seems to be working now.

    I ran a manual refresh and it retrieved the data successfully.

    Not sure exactly what solved it.

    It was mentioned that .Net Framework needs to be updated on the Data Management Gateway Machine as I had .Net 4 installed. 

    Before updating the .Net Framework, I saw a couple of success runs. So, not sure exactly.

    Thanks,

    Grace


    • Edited by Grace M Thursday, April 10, 2014 11:34 AM
    Thursday, April 10, 2014 11:34 AM