Forum Discussion

Clasteruga's avatar
Clasteruga
Frequent Visitor
6 years ago

Data flow Direct query mode

I created PBX file with Data flow data source (direct query mode), but this report don't work in Power bi services  
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Clasteruga 

What is your datasource for Data flow? 

and if you use import model, does it work well?

 

Regards,

Lin

  • Clasteruga's avatar
    Clasteruga
    Frequent Visitor
    6 years ago

    1. Datasource for Data flow = SQL Server

    2. Yes

    • nickyvv's avatar
      nickyvv
      Most Valuable Professional
      6 years ago

      Hi Clasteruga,

       

      To get a few things cleared up:

      1. You're using a Premium capacity
      2. You're using a dataflow that has DQ to a SQL Server?
      3. You're consuming that dataflow in PBI Desktop?

      On point 2: have you gone through the documentation and done the following things?

      Next to that, there are quite a few limitations right now, are you sure you're not hitting one of them?

      For example: DirectQuery for dataflows does not work with the enhanced metadata preview feature enabled.

       

      • Clasteruga's avatar
        Clasteruga
        Frequent Visitor
        6 years ago

        1. You're using a dataflow that has DQ to a SQL Server - I'm using dataflow which download data from SQL server by schedule

        2. You're consuming that dataflow in PBI Desktop - I created PBX file in DQ mode to dataflow

        3. Enable the enhanced compute engine - YES

        4. Enable DirectQuery for dataflows - YES

        But in PBX file DQ mode for dataflow works fine