Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
benntw72
New Member

Using CSV file from Primavera Timescale

I am new to Power Bi. If anyone is familair with Primavera it would help with the question I have. I am trying to load a csv file with the timescale from Primavera. Of course the dates that run horizontal are text based and the number values in the columns are general. I tried to unpivot all the timescale columns. It did not recognize the headers. I then cleaned up my headers, which I don't want to do, and it changed the dates to an attribute. I really need this to be dynamic since date ranges change depending on the project. My end goal is to be able to have all the hours in a histogram budgeted hours daily. Is this possible with Power Bi without being really complex ?

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@benntw72 , check if unpivot other columns can help

select only those which you want to be the same.  in that case I will work even if date column increase

View solution in original post

Hi @benntw72 

Where are you stuck now? Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

 

Best Regards,

Community Support Team _Tang

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

View solution in original post

4 REPLIES 4
benntw72
New Member

I kept all the other columns I didn't want to unpivot. I only wanted the timescale dates to unpivot. I wanted to keep cloumns A thru T the same. I removed column U and then did the unpivot on the rest to the right.Data Screen Shot.JPG

Hi @benntw72 

Where are you stuck now? Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

 

Best Regards,

Community Support Team _Tang

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

I am still stuck at the same point. I tried doing replace, change data type, and then unpivot. I was hoping that I could use Power Bi to clean the data and arrange it the way excel can. I was wrong about it from what I can try and figure out. I think I will stick with trusty old excel to perform my reports. I am starting to see that Power Bi is a lot like MS Access with horizontal data with date headers and number values in columns. Primavera is a unique program that produces excellent CSV files, but outside of excel they do not line up easily. 

amitchandak
Super User
Super User

@benntw72 , check if unpivot other columns can help

select only those which you want to be the same.  in that case I will work even if date column increase

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.