topic Data source greyed out / not visible when uploading from PowerBI desktop (Denodo connector) in Report Server

Data source greyed out / not visible when uploading from PowerBI desktop (Denodo connector)

Anonymous — Thu, 01 Aug 2019 13:57:26 GMT

Hi all,

I have a PowerBI offline desktop version for a report which is connected using the Denodo custom connector to a Oracle database. There exists a report server to which I would need to upload these reports for a larger audience.

When I upload this report to the Report Server, when I click on "manage" for the report to view the data source, the data source is greyed out / disabled and there exists no data source configured.

In the report server itself, I have also configured a data source for the DB consisting of the correct credentials and tested connection. Please let me know why the data source is greyed out?

Re: Data source greyed out / not visible when uploading from PowerBI desktop (Denodo connector)

d_gosbell — Thu, 01 Aug 2019 23:03:25 GMT

It sounds like that specific custom connector may not be currently supported for scheduled refresh in Power BI Report Server. I can't see it listed on the supported data sources list https://docs.microsoft.com/en-us/power-bi/report-server/data-sources Can you maybe switch to using the standard Oracle data source?

Re: Data source greyed out / not visible when uploading from PowerBI desktop (Denodo connector)

Anonymous — Fri, 02 Aug 2019 04:35:11 GMT

Thanks for the reply. However, I did try with ODBC connector as well and still is greyed out.

In the document mentioned, ODBC is mentioned as a connector for import and scheduled refresh which is what I am attempting to do as well.

d_gosbell wrote:
It sounds like that specific custom connector may not be currently supported for scheduled refresh in Power BI Report Server. I can't see it listed on the supported data sources list https://docs.microsoft.com/en-us/power-bi/report-server/data-sources Can you maybe switch to using the standard Oracle data source?

Re: Data source greyed out / not visible when uploading from PowerBI desktop (Denodo connector)

d_gosbell — Fri, 02 Aug 2019 05:30:20 GMT

Anonymous wrote:
Thanks for the reply. However, I did try with ODBC connector as well and still is greyed out.

Can you post a screenshot so that we can see what you are talking about?