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
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? 🤔☹️