Hi Team, I have created a web api which validates the http header and gives the response in Json format. I have added this api as a data source for a report in power bi desktop which is working f...
I am having a similar issue. I have connections to SharePoint lists (OData) and OneDrive-hosted xlsx/csv files. The SharePoint lists have no issues, but the xlsx/csv files (shown as 'Web' in the Data Source Credentials section) will not authenticate.
Refreshing them in Desktop works fine. I need this report to schedule refresh in Service as it is used throughout the day. I am connecting with an organizational account. I have tried storing the files on my work OneDrive and the SharePoint site where the lists exist but I get the same issue.
As the image shows, Power BI informs me I don;t need a Gateway as all data is in the cloud.