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...
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 

 

 

 

DataChant's avatar
DataChant
Most Valuable Professional
9 years ago

Thank you for clarifying.

 

Step #5 is not supported in your scenario. The File-->Import step (step 2) is a one time effort that was designed to migrate from Excel files to Power BI report files.

 

Your only options at this stage are the following ones:

Option 1 - Keep the Excel XLSM files on OneDrive as a data source. Don't use the Data Model, but the grid. Then start a Power BI Desktop report (PBIX) that uses Get Data from Web to load the data from these Excel files. For a refresh, you can automate the refresh of the Excel files using VBA/Object Model. Your Power BI service can be configured to schedule a daily refresh from OneDrive for Business.

Option 2 - Use Power Update to perform the client side refresh on your PBIX file.