Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Connecting to OneDrive Excel Online

I have a report connected to an Excel Sheet in OneDrive.   The data has been updated but the updates are not flowing into the dashboard. I've tried manual refreshes over a 48 hour period.   I dec...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    OK, I think I have solved it! My excel file has a power pivot which wasn't refreshed. So my live data was in an Excel table called 'Tracker' whereas the Power Pivot was calling on data from an old table called 'Table1'. Power BI was uploading Table1. I deleted Table1 from the Data Model and that fixed it.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Oh and another question to ask.  When you are selecting the refresh, have you checked whether the refresh actually completes successfully or does the refresh history show that it produced an error?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Refreshes are successful. Can't see the Edit Query screen. I am in the cloud app. Does it behave the same way?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No it doesnt.  Did you create the project using Power BI Desktop, or Power BI Online?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Power BI Online. and now in the 60 day trial period of Pro.