cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mnijkamp Frequent Visitor
Frequent Visitor

DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

Hi All,

Is it possible to use DirectQuery to a Oracle instance use the report on PowerBI report Server 03-2018?

It connects when the report is opened locally but not on the server. The following error is shown:
    Something went wrong

    We couldn't run the report because we couldn't connect to its data source. The report or data source might not be configured correctly.
    Please try again later or contact support. If you contact support, please provide these details.

    We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.
    Request IDbe5e4945-6a64-1d22-157d-c23683365c28
    TimeFri May 04 2018 14:14:08 GMT+0200 (W. Europe Daylight Time)
    Version15.0.2.389

The report uses embedded database credentials.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

With import mode you can setup automatic scheduled refreshes - you don't need to re-upload the report.

 

You will however need to enter credentials that can connect to your data source in order to refresh the data, and I suspect you'll run into the same issue which is stopping you from using direct query.

 

Re your DirectQuery issue, have you definately configured credentials in the management screen for your report and connected successfully to Oracle?

View solution in original post

5 REPLIES 5
eddieuk1983 Frequent Visitor
Frequent Visitor

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

Hi,

 

We had a similar issue when testing recently.  The solution for us was to use 'Import' instead then upload it to the Report Server.  Have you tried import to see if that works?

 

Cheers

 

Ed

mnijkamp Frequent Visitor
Frequent Visitor

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

Hi Ed,

 

Thank you for your suggestion.

With the option set on 'Import' it's not a problem. But we want to show the report on the SSRS server.

When we do not use DirectQuery mode, the data is not updated untill someone updates it manually on their local machine and re-uploads the report.

We wish to use DirectQuery mode.

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

With import mode you can setup automatic scheduled refreshes - you don't need to re-upload the report.

 

You will however need to enter credentials that can connect to your data source in order to refresh the data, and I suspect you'll run into the same issue which is stopping you from using direct query.

 

Re your DirectQuery issue, have you definately configured credentials in the management screen for your report and connected successfully to Oracle?

View solution in original post

mnijkamp Frequent Visitor
Frequent Visitor

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

Hi jcollinson,

 

I've completely overlooked the management possibilities on the SSRS side. It turns out I needed to setup the credentials there again despite they are already set in the report.

Thank you for your guidance!

Re: DirectQuery to Oracle in PowerBI on PowerBI Report Server 03-2018

No probs, glad you got it sorted 🙂

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 87 members 1,334 guests
Please welcome our newest community members: