Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.