Forum Discussion

mopetkewi's avatar
mopetkewi
Frequent Visitor
1 year ago

Connect to dataflow in Power BI Service?

Is there any way to connect to dataflow from a report in Power BI service directly (as opposed to connect in the desktop)?

11 Replies

  • unfortunately not. You gotta create a semantic model first, which commonly done in Power bi desktop. But you do have the option to create a semantic model in power bi service through either pbi datamart or lakehouse

  • 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

    • mopetkewi's avatar
      mopetkewi
      Frequent Visitor

      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. 

      • Tutu_in_YYC's avatar
        Tutu_in_YYC
        Super User

        I am on premium, and i still cant see dataflow as an option after following the instructions. I will try 


    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User

      suparnababu8 
      I am not able to see Dataflow as a data source. Can you provide a screenshot where dataflow can be selected in the power bi service?

      These are the only options i see:

       



      • -Hemant's avatar
        -Hemant
        Regular Visitor

        Same here with me , Not able to locate Dataflow as a data source in Power Bi service.