cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zakk92 Frequent Visitor
Frequent Visitor

Exporting Data From Online Missing Columns

Hi All,

 

I am trying to export data from my online dashboard. It is quite a large dataset, consisting of 409 columns and 34000 rows. However when I export the data from a visual online, and select 'underlying data', the resultant output only has 273 columns. The row count seems ok. Does anyone know why this is? Or of any potential fixes?

 

Thanks,

Zakk

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Exporting Data From Online Missing Columns

Hi @Zakk92,

 

If the dataset owner set some certain columns to "hidden", they won't show up in the Field list in Desktop and Power BI service. When you export underlying data from a visual, the resultant output won't contain those hidden columns even they are existing in visual.

 

When using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. So, if those missing 273 columns are non-text, they won't be exported. You would need to set the rest columns to be “Text” type  or include them in your visual.

 

Besides, please check whether you hit any limitation of data export.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
v-yulgu-msft Super Contributor
Super Contributor

Re: Exporting Data From Online Missing Columns

Hi @Zakk92,

 

If the dataset owner set some certain columns to "hidden", they won't show up in the Field list in Desktop and Power BI service. When you export underlying data from a visual, the resultant output won't contain those hidden columns even they are existing in visual.

 

When using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. So, if those missing 273 columns are non-text, they won't be exported. You would need to set the rest columns to be “Text” type  or include them in your visual.

 

Besides, please check whether you hit any limitation of data export.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
henrov Occasional Visitor
Occasional Visitor

Re: Exporting Data From Online Missing Columns

I guess this means setting everything to text in the tab modelling?

But what will happen to my datehierarchies and such when I set all to text?

I have som measures that are shown as percentages. Do I need to those to text as well?

 

I am sincerely confused here...

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 89 members 1,649 guests
Please welcome our newest community members: