Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have an data model from PowerPivot in Excel that I used to create a report in PowerBI (Desktop)
My workbook is saved on my One Drive, but when I added measures/updated the Data Model in excel the connections to PowerBI broke. Based on this article I need to upload to the web version of PowerBI and select "Connect, Manage and View Excel in PowerBI" to allow a live link between the two Data Models. When I tried to do that I got this error:
...
Solved! Go to Solution.
Most of the tables in my data model are uploaded from tables in Excel. I do have some tables that pull through Power Query from SalesForce, but I've done the exact same thing in PowerBI without issue.
The workaround I used was publishing my workbook (in Excel) to Office365. This doesn't maintain a live link, but I can refresh in PowerBI (online) and the data model updates.
Hi @IoT,
I test with normal excel file(onedrive) without any issue, so I think your data models are from other data sources, right? It may caused the issue.
Regards,
Xiaoxin Sheng
Most of the tables in my data model are uploaded from tables in Excel. I do have some tables that pull through Power Query from SalesForce, but I've done the exact same thing in PowerBI without issue.
The workaround I used was publishing my workbook (in Excel) to Office365. This doesn't maintain a live link, but I can refresh in PowerBI (online) and the data model updates.