Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Import Excel workbook datamodel from OneDrive

Using Power bi desktop: How do i import an excel data model from a file stored on onedrive. Using the webconnector doesnt seem to bring in the data model or the Powerview tables? And using the file>i...
DataChant's avatar
DataChant
Most Valuable Professional
9 years ago

Could you please explain if you are intersted in one time import from Excel XLSM file to a PBIX report, or do you look for a refresh scenario from XLSM on OneDrive for Business to the PowerBI.com service?

 

If you are looking on the first scenmario, you can import XLSM files like XLSX files.

Start in Power BI Desktop --> File --> Import --> Excel Workbook Content

 

 

In the FIle dialog, browser to the OneDrive for Business location and change the file type from Excel Files (*.xlsx) to All Files (*.*)

 

Then you will see you  XLSM file and will be able to import its Data Model like you did in the XLSX file.

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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