Forum Discussion

ascott's avatar
ascott
Icon for Advocate II rankAdvocate II
10 years ago

Hiding Tables in Desktop

We are looking into hiding tables in Desktop. I have already created the reports and dashboards for our clients but I want to hide the tables now. I am finding that I can only hide tables that are li...
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi Ascott,

 

According to your description, you are trying to hide tables in your Power BI desktop, the issue is that the table disappears for a moment and then comes right back, rigth?

 

I am tring to reproduce this issue without success. After hidden the table, I close the Power BI desktop and reopen it, the tables are still hidden. So in your scenario, please provide us more information, if possbile provide us some screenshot about it, so that we can reproduce this issue and make further analysis.

 

Regards,

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    ascott

    Has anyone been able to really hide a table? In either PBI or PowerPivot?

     

    Hide in Report View is the only option I see in PBI. In PowerPivot Hide from Client Tools.

     

    In both cases the table only gets dim. Saving the file, closing and opening again - still dim - but clearly visible in Relationship View

     

    Also still visible and accessible in Report View.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I´d love to see an answer to this one please?

       

      At the moment I´m working on a project with 2 x 20 text files (don´t ask!) that I then combine into 2 tables with "Append Query". In Power Query I can at least group the two groups of text files, but I´d love to make them invisible other than there, as they are just clutter e.g. in the relationship view.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        9 years ago

        Hi Anonymous,

         

        Instead of making two different queries have you tried to have one single querie compose by differente sources and then combining them in the append?

         

        In the advance view you can add source and keep them as queries and the final result is just one.

         

        See the example below:

         

        let
    Source_1 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUUpUitWJVjICspLALGMgKxnMMgGyUsAsUyArVSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    Format_1 = Table.TransformColumnTypes(Source_1,{{"Column1", Int64.Type}, {"Column2", type text}}),
    Source_2 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlPSUUpMVIrViVYyBzKTksBMCyAzORnMtAQyU1LATEMDIDs1VSk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    
    Format_2 = Table.TransformColumnTypes(Source_2,{{"Column1", Int64.Type}, {"Column2", type text}}),
    Append = Table.Combine({Format_1, Format_2})
in
    Append

        As you can see in my end result I only have one table and the two inputs are "hidden" in the code so the end user only can see the final result.