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 

      • Clasteruga's avatar
        Clasteruga
        Frequent Visitor
        6 years ago

        Am I doing something wrong? 🤔☹️