Forum Discussion
Import Excel workbook datamodel from OneDrive
Let me clarify what i am looking for
1. Connect Power BI desktop to an XLSM file which is stored on OneDrive
2. import the entire data model
3. Create new visuals in the desktop
4. publish report to power bi service
5. have automatic refresh enabled in power bi service with the XLSM file which is stored on OneDrive
Anonymous wrote:
Let me clarify what i am looking for
1. Connect Power BI desktop to an XLSM file which is stored on OneDrive
2. import the entire data model
3. Create new visuals in the desktop
4. publish report to power bi service
5. have automatic refresh enabled in power bi service with the XLSM file which is stored on OneDrive
Hi Anonymous,
In Power BI desktop, we can use web data source to get data from .xlsm workbook, but we can't import PowerPivot table, PowerView table and so on. You can use the Import Workbooks feature suggested by DataChant, you can navigate to the folder in OneDrive for Buiness.
In your scenario, I would suggest you connect to this .xlsm workbook in Power BI Service use "Connect, Manage, and View Excel in Power BI". For more information, please see: Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online.
Best Regards,
Qiuyun Yu
Hi,
I am facing the exact problem. The issue has been escalated and we are waiting for some news from the MSFT Team. The top 2 issues in the following link are related with the problem: http://community.powerbi.com/t5/Issues/idb-p/Issues (http://community.powerbi.com/t5/Issues/Invalid-Credentials-on-Scheduled-Refresh/idi-p/92103 and http://community.powerbi.com/t5/Issues/Invalid-credentials-on-Sharepoint-folder/idi-p/93059)
Regards