topic Re: Report Server Dashboard data not showing in Report Server

Report Server Dashboard data not showing

Varan_15 — Thu, 18 Jul 2024 11:33:58 GMT

Hi All,

I have developed dashboard which is data source as from Oracle database tables after successfully uploaded into PowerBI report server, i could not able to view the dashboard visuals everything showing as data connection error.

note: in report server->manage ->data source -> if i enter my data base credentials it's not accepting (but in powerbi desktop it's accepting and loading all the oracle tables)

Kindly help to view the dashboard.

Re: Report Server Dashboard data not showing

ChrisMuthmann — Thu, 18 Jul 2024 13:32:42 GMT

Maybe there is a firewall blocking the access or the oracle odbc driver and setup are missing on the server?

Re: Report Server Dashboard data not showing

Varan_15 — Thu, 18 Jul 2024 14:06:53 GMT

ChrisMuthmann ,

Thanks for the update, I will double check with firewall access and you mean ODBC data source administrator (system DSN) configuration setup ?

Please note: i can able to connect oracle database tables in powerbi desktop without any issues.

Thanks in advance

Re: Report Server Dashboard data not showing

jbarta_mlchc — Thu, 18 Jul 2024 21:14:39 GMT

Which Authentication Type are you using for the data source?

Re: Report Server Dashboard data not showing

ChrisMuthmann — Mon, 22 Jul 2024 06:59:00 GMT

You are not running Power BI Desktop on the server, aren't you?