cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
renata_andrea
New Member

Fonte de Dados

Olá,

 

Eu utilizo o Powerbi configurado com a fonte de dados do meu banco Oracle. O gateway esta cadastro e funcionando normalmente. Após a criação do relatório, publico o mesmo na minha Workspaces e finaliza com a mensagem que foi realizada com exito. Porém quando clico no link para acessar o relatório web, aparece a seguinte mensagem: " Este relatório não pode acessar a fonte de dados. Entre em contato com Power, o autor, para realizar a correção." e não aparece os dados do relatório.

 

Por favor, me ajudem.

 

Obrigada

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @renata_andrea

 

First, you are using Power BI Service, not Power BI Report Server. Right?

 

Then, are you using "DirectQuery" connection mode? If so, please configure gateway to access the Oracle Database.

 

For details, please refer to this official document: Manage your data source - Oracle - Power BI | Microsoft Docs.

 

Use the data source with DirectQuery connections

Make sure that the server and database names match between Power BI Desktop and the configured data source for the gateway. You also need to make sure your user is listed in the Users tab of the data source to publish DirectQuery datasets. The selection for DirectQuery occurs within Power BI Desktop when you first import data. For more information about how to use DirectQuery, see Use DirectQuery in Power BI Desktop.

After you publish, either from Power BI Desktop or Get Data, your reports should start to work. It might take several minutes after you create the data source within the gateway for the connection to be usable.

 


 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Icey
Community Support
Community Support

Hi @renata_andrea

 

First, you are using Power BI Service, not Power BI Report Server. Right?

 

Then, are you using "DirectQuery" connection mode? If so, please configure gateway to access the Oracle Database.

 

For details, please refer to this official document: Manage your data source - Oracle - Power BI | Microsoft Docs.

 

Use the data source with DirectQuery connections

Make sure that the server and database names match between Power BI Desktop and the configured data source for the gateway. You also need to make sure your user is listed in the Users tab of the data source to publish DirectQuery datasets. The selection for DirectQuery occurs within Power BI Desktop when you first import data. For more information about how to use DirectQuery, see Use DirectQuery in Power BI Desktop.

After you publish, either from Power BI Desktop or Get Data, your reports should start to work. It might take several minutes after you create the data source within the gateway for the connection to be usable.

 


 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!