Forum Discussion

michaelyoung1's avatar
michaelyoung1
Frequent Visitor
5 years ago
Solved

Creating a dataflow to a macro-enabled excel sheet in a SharePoint Folder

Hi,   I'm trying to connect to a .xlsm document in a Sharepoint folder using Power BI online. I've used Power BI desktop and connected to local versions of this document and it's worked completely ...
Dataflow
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, michaelyoung1 

    I'm afraid it couldn't achieve in Power BI for now. The online connector can't  get contents of xlsm files. You may need to convert your file to .xlsx first.

    You can also open a support ticket with MSFT to seek technical support , usually they will have better suggestions.

     

    Related idea you can vote for :

    Data flow with xlsm files 

    If there are enough votes, the Product Team will evaluate and take good consideration about it.

     

    Best Regards,
    Community Support Team _ Eason

     

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, michaelyoung1 

I'm afraid it couldn't achieve in Power BI for now. The online connector can't  get contents of xlsm files. You may need to convert your file to .xlsx first.

You can also open a support ticket with MSFT to seek technical support , usually they will have better suggestions.

 

Related idea you can vote for :

Data flow with xlsm files 

If there are enough votes, the Product Team will evaluate and take good consideration about it.

 

Best Regards,
Community Support Team _ Eason

 

 

 

michaelyoung1's avatar
michaelyoung1
Frequent Visitor
5 years ago

Thanks v-easonf-msft 

Strangely I have figured out that it is in fact possible, going into the advanced editor for an xlsx document and changing the path to my xlsm worked completely fine!

Fingers crossed it doesn't break now.

 

Thanks,

Michael