cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wieke2
New Member

Table visual does not show 3 dots in app

Hi!
I created a dashboard in the online environment of PowerBI and published it in an app. All works fine except for my table visual: it is not showing the 3 dots on the upper right corner. Consequently, users cannot make an Excel export from the table. Does anyone know how to let the 3 dots appear?

wieke2_1-1634309314672.png

 

 

The alternative (click Analyse in Excel) is also not working.

wieke2_0-1634309255778.png

 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @wieke2 ,

 

Limitations and considerations about exporting data

These limitations and considerations apply to Power BI Desktop and the Power BI service, including Power BI Pro and Premium.

  • To export the data from a visual, you need to have Build permission for the underlying dataset.

  • The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.

  • The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000.

  • Export using Underlying data won't work if:

    • the version is older than 2016.

    • the tables in the model don't have a unique key.

    • an administrator or report designer has disabled this feature.

  • Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.

  • When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

    • There are too many columns. Try reducing the number of columns and exporting again.

    • There's data that is difficult to compress.

    • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

  • If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

  • Power BI custom visuals and R visuals aren't currently supported.

  • In Power BI, you can rename a field (column) by double-clicking the field and typing a new name. Power BI refers to the new name as an alias. It's possible that a Power BI report can end up with duplicate field names, but Excel doesn't allow duplicates. So when Power BI exports the data to Excel, the field aliases revert to their original field (column) names.

  • If there are Unicode characters in the .csv file, the text in Excel may not display properly. Examples of Unicode characters are currency symbols and foreign words. You can open the file in Notepad and the Unicode will display correctly. If you want to open the file in Excel, the workaround is to import the .csv. To import the file into Excel:

    1. Open Excel.

    2. Go to the Data tab.

    3. Select Get external data > From text.

    4. Go to the local folder where the file is stored and select the .csv.

  • When exporting to .csv, certain characters will be escaped with a leading ' to prevent script execution when opened in Excel. This happens when:

    • The column is defined as type "text" in the data model, and
    • The first character of the text is one of the following: =, @, +, -
  • Power BI admins can disable the export of data.

  • If a dynamic format string is applied to a measure, the exported data won't preserve this formatting in Excel. Also, visual-specific formatting such as percent of grand total for a measure isn't preserved in Excel.

 

 

Also, Power BI report designers control the types of data export options that are available for their consumers. The choices are:

desktop-report-settings.png

You can download the report in the Power BI service, and then view the setting options in the desktop.

 

 

Best Regards,

Stephen Tao

 

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

2 REPLIES 2
mshenhav
Power BI Team
Power BI Team

Hey @wieke2 ,

 

At this point, users cannot export to excel from Power BI Mobile app. 

I would suggest adding you vote for this request, to help with prioritizing this item higher in our bac;klog.

Microsoft Idea  · export to excel mobile (powerbi.com)

 

Thanks, Maya

v-stephen-msft
Community Support
Community Support

Hi @wieke2 ,

 

Limitations and considerations about exporting data

These limitations and considerations apply to Power BI Desktop and the Power BI service, including Power BI Pro and Premium.

  • To export the data from a visual, you need to have Build permission for the underlying dataset.

  • The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.

  • The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000.

  • Export using Underlying data won't work if:

    • the version is older than 2016.

    • the tables in the model don't have a unique key.

    • an administrator or report designer has disabled this feature.

  • Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.

  • When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

    • There are too many columns. Try reducing the number of columns and exporting again.

    • There's data that is difficult to compress.

    • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

  • If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

  • Power BI custom visuals and R visuals aren't currently supported.

  • In Power BI, you can rename a field (column) by double-clicking the field and typing a new name. Power BI refers to the new name as an alias. It's possible that a Power BI report can end up with duplicate field names, but Excel doesn't allow duplicates. So when Power BI exports the data to Excel, the field aliases revert to their original field (column) names.

  • If there are Unicode characters in the .csv file, the text in Excel may not display properly. Examples of Unicode characters are currency symbols and foreign words. You can open the file in Notepad and the Unicode will display correctly. If you want to open the file in Excel, the workaround is to import the .csv. To import the file into Excel:

    1. Open Excel.

    2. Go to the Data tab.

    3. Select Get external data > From text.

    4. Go to the local folder where the file is stored and select the .csv.

  • When exporting to .csv, certain characters will be escaped with a leading ' to prevent script execution when opened in Excel. This happens when:

    • The column is defined as type "text" in the data model, and
    • The first character of the text is one of the following: =, @, +, -
  • Power BI admins can disable the export of data.

  • If a dynamic format string is applied to a measure, the exported data won't preserve this formatting in Excel. Also, visual-specific formatting such as percent of grand total for a measure isn't preserved in Excel.

 

 

Also, Power BI report designers control the types of data export options that are available for their consumers. The choices are:

desktop-report-settings.png

You can download the report in the Power BI service, and then view the setting options in the desktop.

 

 

Best Regards,

Stephen Tao

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors