Solved: Dataset from Onedrive

Anonymous · ‎01-05-2023

full disclosure I'm a newbie at PowerBi

Im trying to create a dataset in a workspace, I do all the steps like new dataset, create new content from a file, onedrive, import. Works great

however when I analyse in excel that data that's like 2000+ rows and 30+ columns is in a pivot table, even tho it's originally formatted as a table.

my question is is there any way to view the data without it being in pivot form, and if anyone wanted to add a row how do they go and do that if it's stuck in pivot!

TIA

v-yueyunzh-msft · ‎01-05-2023

Hi, @Anonymous

According to your requirements description, you are a PBI newbie developer, you try to create a dataset in the workspace of PBI service, perform all the steps, such as new dataset, create new content from a file, onedrive, import, all can be achieved, but you also want to implement "view the data without it being in pivot form", I think for this need you can try to continue using Power BI Desktop is a native PBI data processing and development tool to further implement your needs, because it includes a data preprocessing tool called Power query editor, which can support you to view a preview of the data preprocessing in any data conversion situation, and import the data into the PBI to form a data set after completing your needs. For details, you can refer to this document:

What is Power BI Desktop? - Power BI | Microsoft Learn

And regarding your other requirement, "anyone wanted to add a row how do they go and do that if it's stuck in pivot", I think the first thing you need to understand about this requirement is that PBI is a product tool that links data processing and presentation of data sources, but never writes back and edits the data source. To add a row to the PBI dataset, this operation can generally be achieved through the Union or Append query operation, you can refer to this document for details:

Append queries - Power Query | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

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

View solution in original post

v-yueyunzh-msft · ‎01-05-2023

Hi, @Anonymous

According to your requirements description, you are a PBI newbie developer, you try to create a dataset in the workspace of PBI service, perform all the steps, such as new dataset, create new content from a file, onedrive, import, all can be achieved, but you also want to implement "view the data without it being in pivot form", I think for this need you can try to continue using Power BI Desktop is a native PBI data processing and development tool to further implement your needs, because it includes a data preprocessing tool called Power query editor, which can support you to view a preview of the data preprocessing in any data conversion situation, and import the data into the PBI to form a data set after completing your needs. For details, you can refer to this document:

What is Power BI Desktop? - Power BI | Microsoft Learn

And regarding your other requirement, "anyone wanted to add a row how do they go and do that if it's stuck in pivot", I think the first thing you need to understand about this requirement is that PBI is a product tool that links data processing and presentation of data sources, but never writes back and edits the data source. To add a row to the PBI dataset, this operation can generally be achieved through the Union or Append query operation, you can refer to this document for details:

Append queries - Power Query | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

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