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,

What type of authentication do you use in Power BI Desktop? After connecting to the Excel file using web connector, please use "organizational account" authentication .



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I Try this way: Get data -> Web-> then I paste the SP online link to the Excel file and shows me the error as shown in the picture:

 

Note: I have the most recent Power BI Desktop version. I try it at home and at work network.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    What URL do you use to connect to the Excel? The URL should be like: https://XXXXX.sharepoint.com/sitename/Shared Documents/Foldername/Excelname.xlsx.

    And do you use Azuze AD account to sign in? In the highlighted textbox of the screenshot below, choose ensure that  you choose Excel level URL.


    Regards,
    Lydia