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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I appreciate the answer, I really do, but this is pushing the boundaries of my understanding of M. I´m only playing around with CSV files but it looks to me like the example is dealing with binary files.

 

I might give something like this a whirl one day, but the better strategy I think is to avoid having to work with dumps of text files and go directly to the source db.

 

Thanks - Ragnar

 

 

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

Anonymous,

 

The example is with binary but we can do it with all PBI source datas, I just wanted to show that we can have I single query that combines several data sources and the end user will only see the final result.

 

If you want something based on the CSV I can set up a small example also.

 

regards,

 

Mfelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Mfelix,

     

    I would be very glad if you did - thanks. And for extra bonus points, could you show how to pick out field names, change the field names, and set data types (e.g. specify text field, a date field etc)?

     

    However I do worry that as I'm working with semicolons as the field delimiter, and the input files in a few cases have semicolons in them, I might run into trouble. At least when I used Power Query I could see by looking at the last column if the fields had shifted due to a semicolon in the text. 

     

    But I'd still love to learn and understand the method you're describing.

     

    Thanks again, R.

    • 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