Forum Discussion

bao871's avatar
bao871
New Member
5 years ago
Solved

Cannot Load Model: BI Datasets

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

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

 

 

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    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

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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

    • bao871's avatar
      bao871
      New Member
      5 years ago

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

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

       

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    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

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    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