Forum Discussion

nunnc01's avatar
nunnc01
Helper II
8 years ago

Basic report/query building

Hi all,

I think I must be missing something obvious but if I have connected to my data tables and added the relationships, how do I then just bring together the relevant columns from my tables into one data view. For example in crystal reports and Access you get the data and build the relationships and then you create the query/report by simply selecting your chosen fields and adding calculated fields if required.

I do not need to create visuals in this example, just want to build a data report that I can then export into Excel.

Can anyone offer any advice please?
Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Did your bring in the tables and created the relationships? That's usually the big hurdle as BI requires one of the tables to have a distinct field to connect to. 

     

    ONe they are connected you simply pull the fieldsa into a table. You do not have to see all the fields in BI if there are many. 

     

    Then export to .csv. To export, click on the frame of the Visiual/table, in the upper right corner of the visual you will see three dots. Click on the dots and export. 

     

    If there is too much data (too many rows) you will need to filter and export in sections. 

     

    Is that all you needed? 

    • nunnc01's avatar
      nunnc01
      Helper II
      8 years ago
      When you say pull them into a table, do you mean the table visualisation or an actual table in the edit query section?

      The export row limitation is a big problem. Surely there must be a way of exporting all the rows from my results??

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi nunnc01,

         

        It's the Table visualization. Why not connecting to the data source directly? What's the data source?

         

        Best Regards,

        Dale