Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Direct Query - Limits ability to manipulate data (removes the Data section)

I am new to Power BI and have tried to get up to speed on Direct Query vs. Import.  Most makes sense from the research I have done but I am still struggling with users saying that Direct Query limiti...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    Yes, you create a table visual including all the columns, you will view all data you loaded.

    Best Regards,
    Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ooops also forgot to ask...

 

What does it really matter if there is no "Data" section?  Is there any functionality lost by not having this section?

 

Steve

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

No "Data" section is a designed behaviour in Power BI, you can create an idea here. I test getting data from SQL Server in Direct Query Mode, you can create some calculated column or measure using DAX as the picture above shown. Please confirm you use Diect Query or Live connection.

Best Regards,
Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Angelia -

     

    I can get Direct Query.

     

    My question - I still don't understand what the data section gives me that I can't get elsewhere within PowerBI? Even with out data (Direct Query) section I can create calc measures and columns.

     

    Thanks,

    Steve

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous,

      Yes, you create a table visual including all the columns, you will view all data you loaded.

      Best Regards,
      Angelia