Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
I need to connect to ODBC data source in Power BI report builder, but I don't see any option in dropdown in the latest version. Is it currently supported?
Solved! Go to Solution.
Hi @Anonymous ,
" will it populate live data or it needs to be refreshed."
Because Power BI does not import the data, you don't need to run a data refresh. The queries are sent directly to the data source.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Supported data sources for Power BI paginated reports
Power BI Report Builder does not support 'ODBC'.
You can create this dataset in PBI Desktop, then publish it to Service, and finally connect in Builder.
Step1
Step2
Step3, add Power BI dataset connection
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Lionel @v-lionel-msft,
Thanks for your response! If I create a PBI dataset with ODBC using direct query and use that in Report builder, will it populate live data or it needs to be refreshed. We have a requirement to show live data from our data source (Marklogic).
Hi @Anonymous ,
" will it populate live data or it needs to be refreshed."
Because Power BI does not import the data, you don't need to run a data refresh. The queries are sent directly to the data source.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks heaps Lionel 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |