cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bao871
New Member

Cannot Load Model: BI Datasets

I set a Datasets in PowerBI workspace, and set the dataflow link with FORMS in Automate.

bao871_1-1623056561319.png

what is so strange I can load Datasets in one new PBI file, but can not load it into a existing PBI file.

bao871_3-1623056612000.png

 

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @bao871 ,

If only the name of your Tabular Model datasource has changed Power BI will prompt you to edit the connection.

However, if you were connecting to a Perspective which no-longer exists you will get the following error:

Cannot Load Model

We couldn't connect to your Analysis Services database. Double-check that your server and database names are correct, and that you have permission to access them.

The cube either does not exist or has not been processed.

error message

To fix this you must edit the PBIX file directly.

Rename the file as a zip and extract it.

In the root folder there is a 'Connections' file. Edit it to remove the 'Cube=' reference:

{"Version":1,
"Connections":[{"Name":"EntityDataSource",
"ConnectionString":"Data Source=TEST-DB;Initial Catalog=TestAS;Cube=Labour",
"ConnectionType":"analysisServicesDatabaseLive"}]}

becomes

{"Version":1,
"Connections":[{"Name":"EntityDataSource",
"ConnectionString":"Data Source=TEST-DB;Initial Catalog=TestAS",
"ConnectionType":"analysisServicesDatabaseLive"}]}

Then delete the 'SecurityBindings' file. If you don't Power BI with throw this error:

Unable to open document

This file is corrupted or was created by an unrecognized version of Power BI Desktop. It can't be opened.

unable to open document error

Now zip the files up again and rename it as a .pbix file.

If you still get a 'corrupted file' message be sure you did not include the folder that you expanded the PBIX into in the new zip. The root of the new zip file must hold the Reports folder, [Content_Types].xml, Connections, DataMashup, etc

AFAIK You can make any change to a PBIX file this way, the key is to delete SecurityBindings.

 

 

Wish it is helpful for you!

 

Best Regards

Lucien

View solution in original post

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @bao871 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

 

 

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi @bao871 ,

If only the name of your Tabular Model datasource has changed Power BI will prompt you to edit the connection.

However, if you were connecting to a Perspective which no-longer exists you will get the following error:

Cannot Load Model

We couldn't connect to your Analysis Services database. Double-check that your server and database names are correct, and that you have permission to access them.

The cube either does not exist or has not been processed.

error message

To fix this you must edit the PBIX file directly.

Rename the file as a zip and extract it.

In the root folder there is a 'Connections' file. Edit it to remove the 'Cube=' reference:

{"Version":1,
"Connections":[{"Name":"EntityDataSource",
"ConnectionString":"Data Source=TEST-DB;Initial Catalog=TestAS;Cube=Labour",
"ConnectionType":"analysisServicesDatabaseLive"}]}

becomes

{"Version":1,
"Connections":[{"Name":"EntityDataSource",
"ConnectionString":"Data Source=TEST-DB;Initial Catalog=TestAS",
"ConnectionType":"analysisServicesDatabaseLive"}]}

Then delete the 'SecurityBindings' file. If you don't Power BI with throw this error:

Unable to open document

This file is corrupted or was created by an unrecognized version of Power BI Desktop. It can't be opened.

unable to open document error

Now zip the files up again and rename it as a .pbix file.

If you still get a 'corrupted file' message be sure you did not include the folder that you expanded the PBIX into in the new zip. The root of the new zip file must hold the Reports folder, [Content_Types].xml, Connections, DataMashup, etc

AFAIK You can make any change to a PBIX file this way, the key is to delete SecurityBindings.

 

 

Wish it is helpful for you!

 

Best Regards

Lucien

View solution in original post

Pragati11
Super User
Super User

Hi @bao871 ,

 

To me this looks like a permision issue. But as you said you can access it in the other Power BI report, then check the database names.

Are these both power bi files on same machine or different machines/servers?

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Yes, both reports are in the same machine...

how can i check the permission setting, i only find here, and I am the admin.

bao871_0-1623118725909.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.