Deliver superior customer experiences with an AI-driven platform for creating and deploying cognitive chatbots
Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
A complete cloud platform for an app or your entire digital business
Detect and predict anomalies by automating machine learning to achieve higher asset uptime and maximized yield
Automate decision processes with a no-code business rules engine
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Personalize and optimize the customer experience across digital touchpoints
Build, protect and deploy apps across any platform and mobile device
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
In Power BI, by default any ODBC driver or some of the data sources like Salesforce you don’t get to DirectQuery them. You would have to load the data before you can start visualizing the data. In this article you will learn how you can DirectQuery any datasource with the help of Progress DataDirect ODBC drivers which are certified to work with Power BI.
To enable DirectQuery, Microsoft provides a Data Connector SDK and using it you would have to create an extension that enables DirectQuery. But this can be tricky if you are not sure how to do this. Don’t worry, Progress DataDirect has got you covered.
In this article, let’s see how you can enable DirectQuery for Hive using Progress DataDirect Hive ODBC driver. You can use this same method for any DataDirect ODBC drivers, we will provide you with Power BI connectors that enables DirectQuery for any datasource.
Note: This extension is not production ready, please contact us for the stable version.
If your Power BI is already running, save your work and Restart Power BI for the extension to show up.
I hope this article helped you on how you can Direct Query Progress DataDirect ODBC drivers. All the Progress DataDirect ODBC drivers like Salesforce, SQL Server, Oracle, IBM DB2, PostgreSQL, MySQL, Eloqua etc.., and the drivers you can build using OpenAccess SDK are fully compliant to ODBC standards, and are internally certified to work with Power BI. Feel free to try these for your projects and if you have any questions or issues, feel free to contact us.
Connect any data source to any application
Discussions, tips and tricks for
DataDirect Connect drivers
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.