locked
Can't refresh OneDrive data in Power Bi Service RRS feed

  • Question

  • I created a report using Power Bi Desktop. The data source is an Excel file in OneDrive (Get Data -> Web). Whenever I click on refresh in Power Bi Desktop, it refreshes the data correctly.

     

    Then I published this report to the Power Bi Service. Whenever I click on refresh on Power Bi Service, it doesn't refresh the data. It gives the error: "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."

     

    I also have Scheduled Refresh enabled, but whenever it tries to refresh according to my scheduled refresh, it says "Refresh in progress" and it gets stuck there forever. It never finishes refreshing.

     

    I don't have any gateway because Power Bi says it's not necessary for my type of data source.

     

    I heard somewhere that I needed to select oauth2 as an authentication method, but I don't have that option. When I click on (Data source credentials -> authentication method), I can only choose between "Anonymous", "Windows" and "Basic". There is no oauth2 option available.

     

    So how can I refresh my data in Power Bi Service?

     

    Thanks

    Tuesday, March 12, 2019 4:06 PM

All replies