Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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?
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?
@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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.