Forum Discussion
Creating a dataflow to a macro-enabled excel sheet in a SharePoint Folder
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 :
If there are enough votes, the Product Team will evaluate and take good consideration about it.
Best Regards,
Community Support Team _ Eason
michaelyoung1
Can you check this link: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Thanks for your reply. I've already tried this having seen it in a question elsewhere.
For some reason when I do this method, after Step 3 I get this error message
Occasionally it makes it through to step 4 but I have to close and reopen Power BI, and I get this error anyway after clicking "connect" here. This is despite being an Owner of said SharePoint, and being able to connect to other folders in the same SharePoint completely fine using dataflows in Power BI online.
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 :
If there are enough votes, the Product Team will evaluate and take good consideration about it.
Best Regards,
Community Support Team _ EasonThanks 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