Forum Discussion
Fonte de Dados
- 5 years ago
Hi Anonymous
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.
Hi Anonymous
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.
- Danilo_Mega2 years agoNew Member
Boa tarde, estou com o mesmo problema de conexao utilizando Sql Server e Dataquery.
Pode me ajudar?