Forum Discussion

Hidrolix's avatar
Hidrolix
Frequent Visitor
2 years ago

Direct query Split Columns

Hi all, 

 

I am just starting with PowerBI, so still a steep curve ahead 🙂

As company and security reasons we are not allowed to use import mode and only direct query.

I got an table with seperation markers (space) in the MD table like:

Idle Capacity CA111

Idle Capacity CA112

The end result should be that Idle, Capacity and CAXXX are seperate columns.

 

I looked into several options on this forum, but I cant seem to find the awnser', no matter what I can't get it to work.

tried several DAX codes but none seem to work or I am doing something wrong.

 

 

So please can someone help me with this 🙂

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Hidrolix ,

    If you want to spill columns in Direct Query mode, it is not possible to do so.

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

    • Hidrolix's avatar
      Hidrolix
      Frequent Visitor
      2 years ago

      Thanks for the Response 🙂

      I have added a small example data. 

      Goal: 
      To split the management domain further into the availability zones with Slicers visual in PowerBI
      The availability zone's are the Red/Blue behind the management Domain (storage/network/Mainframe)

      BuildingRoomManagement domain (MD)
      Building 1Room 1Storage_Red
      Building 1Room 1Storage_Rlue
      Building 2Room 1Network_Blue
      Building 2Room 1Network_Red
      Building 2Room 2Mainframe Red
      Building 2Room 2Mainframe Blue