Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have a question about maintaining data models in Excel and Power BI. I have a data model that my team and I built in Excel. I know there is an option in Power BI Desktop to import Excel workbook contents, which will import the entire data model, but this creates another copy of it. Since we are constantly updating the model in Excel, it would be nice to have the Power BI report point to that Excel model and update whenever we add a new measure or column so that we don't have to recreate it.
I know in Excel you can export the data model to Power BI service, and then import it from the service into Desktop. However, it seems I have to re-export the data model to service every time I make a change (or else the changes don't show up when I refresh). Does anyone know of a better method to avoid having to maintain two data models? Any help is appreciated!
Solved! Go to Solution.
Yes, I tried that and it seems to work. Thanks Xi Jin!
Hi @Anonymous,
As I know, both import Excel workbook contents and export the data model to Power BI service cannot update data synchronously.
To achieve your requirement, I think you can try to upload your excel file to SharePoint. And use OneDrive to refresh. Then make Power BI connect to the file on SharePoint.
Thanks,
Xi Jin.
Yes, I tried that and it seems to work. Thanks Xi Jin!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |