Forum Discussion
Connect to dataflow in Power BI Service?
Hi mopetkewi
Yes, you can connect to a dataflow directly from a report in the Power BI service using DirectQuery. This allows you to connect to a dataflow without needing to import the data into Power BI Desktop.
Follow below steps to Connect to a Dataflow Using DirectQuery
Enable Enhanced Compute Engine:
- Ensure the enhanced compute engine is enabled for your dataflow. This setting is necessary for DirectQuery to work.
- Go to the dataflow settings in the Power BI service, toggle the enhanced compute engine to βOn,β and refresh the dataflow.
Create a Report in Power BI Service:
- In the Power BI service, navigate to the workspace where your dataflow is located.
- Click on Create > Report.
Select Data Source:
- Choose Dataflows as your data source.
- Select the dataflow you want to connect to. You will be prompted to choose between DirectQuery and Import. Select DirectQuery.
Build Your Report:
- Once connected, you can start building your report using the data from the dataflow. The data will be queried in real-time, providing up-to-date information without the need for manual refreshes
Need additinal info visit this - https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery
Thanks
I really appreciate this detailed answer. I tried to check the "Enable Enhanced Compute Engine" option but it was not available to me (grayed out). I think this feature may only be an option for premium license from what I found on the web. I have a pro license.