Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
team_steve
Advocate I
Advocate I

Get Data from existing data model

Hello everyone, 

I've created a report with a dataset and published both to a workspace. The dataset has had some modelling work and so I would like to reuse it. To do this, I start a new report, then click 'Get data from another source', this opens the Get Data screen. I click Power Platform and Power BI Datasets. The 'Select a dataset to create a report' screen appears and shows a list of my datasets. However, when I select a dataset I get the following message. Cannot load model. Screen shot below.

 

CannotLoadModel.gif

I'm certain the dataset is there and I have permission, if not I don't think it would have allowed me to select it. 
Is this the correct way to connect to an existing dataset? Any help to explain/resolve this would be amazing. 
Don't know if this is relevent but the data is on premise but I have a refresh schedule in place via the data gateway. 

Thank you

2 ACCEPTED SOLUTIONS
V-lianl-msft
Community Support
Community Support

Hi @team_steve ,

 

Please refer to these threads:

https://community.powerbi.com/t5/Desktop/Error-when-using-Power-BI-dataset-as-datasource-quot-Cannot... 

https://community.powerbi.com/t5/Desktop/Cannot-load-model-Error/td-p/812574 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you so much Liang. 
The solution to this was simply to use Power BI Desktop from a Windows 10 computer, then it worked fine, I can connect to existing datasets and have the 'One version of the truth' I wanted. 
Frustrating because the error message points to a completely different problem and because, as far as I can tell, everything else works in Windows 7. Anyway, it's working great now and I'm very happy. 
You are my hero!
Thanks
Steve 

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Hi @team_steve ,

 

Please refer to these threads:

https://community.powerbi.com/t5/Desktop/Error-when-using-Power-BI-dataset-as-datasource-quot-Cannot... 

https://community.powerbi.com/t5/Desktop/Cannot-load-model-Error/td-p/812574 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much Liang. 
The solution to this was simply to use Power BI Desktop from a Windows 10 computer, then it worked fine, I can connect to existing datasets and have the 'One version of the truth' I wanted. 
Frustrating because the error message points to a completely different problem and because, as far as I can tell, everything else works in Windows 7. Anyway, it's working great now and I'm very happy. 
You are my hero!
Thanks
Steve 

DataInsights
Super User
Super User

@team_steve,

 

You could try the following:

 

1. Ensure that both the published report and new report are using the same Power BI Desktop version.

 

2. The link below may be helpful. One suggestion is to disable the following setting: In Power BI Desktop, go to Options —> Global —> Preview Features; turn off “Store datasets using enhanced metadata format”. However, this setting has been removed in the November 2020 version.

 

https://community.powerbi.com/t5/Desktop/Error-Cannot-load-model/td-p/1101022 

 

If this doesn’t resolve it, you might try creating a test report, publish it to the same workspace, and see if you can connect to its dataset. You could also try a different workspace, as well as have a different user try to connect to the dataset.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.