import XLSM graph to power bi desktop

[hani_gamini]

Hi,

I have XLSM file that have many sheet and graph and formula in excel,

i want import all graph and content and data to power bi desktop , but only data is imported!

can anyone help me?

[v-caliao-msft]

Hi Gamini,

Based on the document
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/#which-work...

• Power Query queries
• Power Pivot External Data Connections
• Linked Tables or Current Workbook tables
• Data Model Calculated Columns, Measures, Data Categories and Relationships
• Power View Worksheets

In your scenario, if the grahp are pivot charts, then is won't be inported into Power BI desktop.

Regards,

Charlie Liao

[mahimabedi]

Can i import XLSM data model if the file is stored on OneDrive? I tried using the web connector, but that only brings in the tables not the data model

[Greg_Deckler]

That kind of graph and such is it, is it Power View? I have imported XLSX files into Power BI that have Power View reports in them and they seem to work 9 times out of 10, some of the visualization types in Power View are not supported. Or are these Excel graphs/charts that are not Power View? If that is the case, I have no idea whether or not those are suppored, my guess would be no, but never tried. I assume you are using the "File | Import | Excel Workbook Contents" feature in the Desktop.