Enabling DirectQuery for live connections
To be able to use this feature, we have to have it enabled in the Power BI service and Power BI Desktop. The next subsections explain how to do so.
Allow DirectQuery connections to Power BI datasets in the Power BI service
If you are a Power BI administrator, you need to enable Allow DirectQuery connections to Power BI datasets in the admin portal from the Power BI service. If you are not an admin, then you may ask your Power BI administrators to enable it for you. Either way, the following steps show how to enable this feature in the Power BI service:
- Click the gear button (
) located at the top right in the Power BI service. - Click Admin portal.
- Expand the Allow DirectQuery connections to Power BI datasets setting under the Export and sharing settings section.
- You may enable this feature for The entire organization or just Specific security groups depending on your organizational data governance policies...
