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...
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi Anonymous,

 

The Power BI works with power query to treat the file so if you already have knowledge in that part the transiction will be easy, so the picking fileds, changing names set data types you already now how to do it.

 

Just one additional question are all your CSV files equal or do they have different columns and the end result is differente from the starting files?

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Happy New Year Mfelix!

 

The columns have different names (although some are the same) as they originate from different ERP systems.  And the end result is different as I only use a fraction of the columns.

 

Good point about just looking at the code generated from just using Power Query. Of course I could adopt those into a M script that does all sorts of clever things.

 

Regards,

 

Ragnar

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Turns out the solution to my problem was very simple indeed - just right click on the table in Power Query and uncheck "Enable Load" (but leaving the "Include in Refresh"). 

     

    :-) Ragnar