Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When 'exporting underlying data' from a card on the Power BI online service I need to have the exported columns (~20+ of them) be in a specific order. I am pulling the data in with SQL in the Advanced Editor. I was unable to figure out how the order of columns is determined and have already unsuccessfully tried the following:
The order also does not appear to be impacted by the order of the fields in the database tables either. I would just create a separate table for this and specify the column order there but my client needs it to export directly from the card in a specific order. I know that with a Table the order of exported data is determined by the order of what you drag fields in by but that doesn't impact my card.
Does anyone know how the order of columns of the export underlying data is determined?
Solved! Go to Solution.
Hi @Anonymous,
It seems we can't determined the order. Please create an idea here for this feature.
Best Regards,
Dale
Hi
Is this feature is available in power bi services or desktop?
we are also expecting the specific order once the data exported from underlying data.
as of now the data is exported by default with some order.
please suggest if this feature is available? or need to write any functionality?
Hi @Anonymous,
It seems we can't determined the order. Please create an idea here for this feature.
Best Regards,
Dale