Forum Discussion
OData authentication to Power BI Report Server shared dataset
Anonymous wrote:
These data sources are specific to Power BI reports used within Power BI Report Server. For information about data sources supported with paginated reports (.rdl), see Data Sources Supported by Reporting Services.
of the data source as OData in "Type" dropdown (a non-functional dropdown). That makes me think that it is implied that OData is supported on PBIRS.
Yep, I'm more than familiar with that page, it's the one you linked in your initial response so I did not bother re-linking to it. Unfortunately it does not list the authentication types supported by PBIRS
Anonymous wrote:
This documentation clearly mentions that Scheduled Refreshes are supported for OData Feed and that is what I am using with-in a PBIX files (not an RDL file).
The problem is that OData is a protocol not a specific source. It can be implemented in different ways and the spec does not mandate any specific authentication method. You will find that OData sources that use anonymous or windows auth work fine (http basic auth may work too but I have not tried that).
Sharepoint Online Lists for example use OData as their underlying protocol, but like DevOps they use OAuth for authentication (which Power BI shows as "Organizational Accout").
However I just had a look at the DevOps documentation here https://docs.microsoft.com/en-us/azure/devops/report/powerbi/client-authentication-options?view=azure-devops and it talks about the fact that you can use basic authentication or a personal access token - have you tried using either of those options for authentication or are you using the "Organizational Account" option? You may find that setting up basic auth (which I think you will have to change in Desktop) might allow this to work.
Giving Basic Authentication a try is on my list. And yes, as you pointed out, and as remembered from Azure DevOps Connector, it requires an Organizational Account option for authentication. However, this option does not show-up as an available authentication method for OData.
Will let the thread know if Basic Authentication worked or not (subject to my Org Security Team being fine enable it.)