Forum Discussion

gfross's avatar
gfross
Helper I
3 years ago
Solved

Table Direct in Query Designer is not Available

I didn't see a location for Power BI Report Builder so I created this under Report Server. I'm having issues being able to use the Table Direct option in Query Designer. I'm trying to connect to a My...
report builder
  • gfross's avatar
    gfross
    3 years ago

    I found a solution. I was able to create a datasource in Power BI Desktop, then I published it, and I was able to select that published datasource in Report Builder.

v-luwang-msft's avatar
v-luwang-msft
Community Support
3 years ago

Hi gfross ，

1. In Power BI report builder, create a data source which uses Oracle data source connector. 

 

 

2. Create a dataset based on the data source created in above step, you can write query to retrieve data. 

 

 

3. To create parameters follow this document: https://docs.microsoft.com/en-us/power-bi/report-builder-parameters

 

And about text_based query ,pls refer:

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/text-based-query-designer-user-interface-report-builder?view=sql-server-ver16 

 

The following may be helpful for you:

https://stackoverflow.com/questions/37978344/ssdt-for-ssrs-unable-to-connect-to-data-source-datasource1-the-selected-data 

 

 

Best Regards

Lucien