Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Refresh Schedule under domain controller

My report is made up on the data from online sharepoint list (which will be edited almost every hour by users) and a few excel file (almost static) on my desktop. To have my report published with mos...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    Based on your description, you put Excel file on your desktop. Do you use gateway to refresh the report in Power BI Service? What error message do you get when you connect to work network in the office?

    In your scenario, you can upload Excel file to SharePoint Online, and create your Power BI Desktop with only online data sources. This way, no gateway is required and you should be able to refresh the dataset in Power BI Service.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

How is the issue going?

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Lydia,

     

    Thanks for your support in that. I just tried to connect an Excel file ( which I was the owner of) to the power BI desktop, and it just went through very well. My conclusion would be that I needed to be the owner of that Excel file on sharepoint to be able to pull in its tables.

    However, I would like to make sure that was the cause, and any other justification is welcome.