Forum Discussion
Paginated Report Builder
Hi,
I'm trying to create a new report with the new Power B report builder tool with Oracle as a datsource. When creating a new dataset the option to choose the "tables" is grayed out? I can just write/import a sql query or a stored procedure.
Is it the limitation when using Oracle as suupose to other data sources?
Thanks!
PG.
5 Replies
luisrhResponsive Resident
This is probably a limitation of the driver that you are using. Some other DBs drivers also don't have that capability.
The best thing is to use a view or define the SQL directly - even for SQL Server which is a first class citizen when it comes to supporting table views and SQL generation from that view.
good luck!
Luis
- luisrh
You are welcome. I doubt that there will be support for Oracle downstream the way you expect on the report builder side. There are enough differences between the SQL syntax and if the Oracle native drivers don't support some of the features that the builder requires, then it will also be a problem. My suggestion is you use a tool outside that may generate the SQL for you, then you can paste into ReportBuilder query. Query Builder is such a tool -
Good luck!
Luis
- chrisfin
Power BI Team
Yes, this is related to the specific driver used for the Oracle provider. There has always been limitations like this for non-Microsoft SQL datasources in RB.
