Is there any way to display Excel data in power bi in exact way as we have in excel

[UHS]

Hi All,

i am preparing a power bi report using the excel data source. I have around 300 rows in excel which i want to display in power bi in exact same way. Eg: row 1 in excel should be displayed in row 1 in power bi and likewise other rows as well. i dont have an unique column and cannot even sort it on basis of any particular column. But i would need it in a exact samer way as i have in excel. is there any way to freeze the rows in same place in power bi as we have in excel ? How can i achieve that?

regards,

UHS

[JamesLee94]

To display Excel data in Power BI exactly as it is, add an index column in Excel to maintain row order, as Power BI does not automatically preserve this. Import the data using this index to sort the rows accordingly. Power BI does not support freezing rows like Excel. For automatic data updates, consider using Skyvia for data integration between Excel and Power BI.

[Anonymous]

Hi @UHS ,

You may consider to upload the workbook to Power BI Service.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#local-excel-work... .

Or publish the workbook to Power BI Service.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-publish-from-excel .

Best Regards,

Jay

[Arul]

@UHS ,

Fields are automatically sorted implicitly in Power BI. If you want to show the data as how it is excel you can try to create index column in Power Query Editor and then sort the original column using index column.

Please refer the attached thread,

https://community.powerbi.com/t5/Desktop/Disable-sorting-in-Table/td-p/1616130 

Thanks,

Arul

[UHS]

@Arul Thanks for your quick response Artul. I did that but the problem i am facing is, when i have to export the table visual from power bi in csv format that index column in also coming in the csv and i dont want that. I tried to hide that column in the table visual but at the time of exporting the table from power bi that column is also getting export along with other data. And if i am removeing it the whole sorting is gone 😞 Is there any other way that i can do?