Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Scheduled Refreshes on Cloud Error with Data Source Connectivity

Hi,  I created a report that has a data table (sql database) that pulls from another data table (static excel file). However, the excel file has since been moved/deleted (not by my doing) and I am...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Do you have a replacement file with the holidays?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You are holding the wrong end of the OneDrive stick.  Go to your OneDrive folder, right click, "View Online"  and then use the SharePoint Folder connector to get to the file (NOT the Web connector).

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I do not have access to the folder as it is on a previous employees laptop. Is there a way around?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Do you have the PBIX file or can you download it from the service?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I do have the PBIX file.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Go to the Power Query Editor and remove that data source.