Forum Discussion

Leann's avatar
Leann
Regular Visitor
9 years ago
Solved

stucking on creating connection in model

Hi, I have a data model in power bi desktop, the tables are loaded from ssas server, and it refreshed data well yesterday. But today when I pulled in more data (400,000 rows to 17,986,280 rows) to ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Leann,

    Do  you choose “Import” or “Connect Live” mode to connect to SSAS database in Power BI Desktop? I would recommend uncheck the following options in Power BI Desktop and then refresh your data model.


    If the above error still occurs, please try to re-connect to the SSAS database in Power BI Desktop, pull in columns and rows you need to build report.


    Regards,
    Lydia

Leann's avatar
Leann
Regular Visitor
9 years ago

Hi LyidaAnonymous, 

Thanks a lot for your help. After I disable the features you mentioned plus "import relationship from data source", I can load the table smoothly. :-)

I found the cause might be the new source of the dimension table contains duplicate rows, it caused the hang on problem.

one more question, if I refresh the data from power bi service, will it check the relationship as well? or is related to what I set in the option power bi desktop? Thanks for your answer.  :-)

 

Have a nice weekend! 

LeAnn

gustavotorrealb's avatar
gustavotorrealb
Frequent Visitor
8 years ago

I have the same problem, I followed the same steps as in your proposed solution, but i'm still having issues refreshing the data.

 

Can anyone help me?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I cannot refresh my data. Creating connection in model never finishes. See printscreen. Data source settings are adjusted due to changed network name but oke now. It has always worked before.

     

    • Sgandalf's avatar
      Sgandalf
      Regular Visitor
      6 years ago

      Hi Hypeerchef1969,

       

      I have also not been able to resolve my being stuck on "creating connection in model" using the options in the suggested solution above.

       

      Have you managed to resolve your issue?

       

      I would be grateful to hear from you or anybody else with suggestions as what to try next.

      Siggy

      • Sgandalf's avatar
        Sgandalf
        Regular Visitor
        6 years ago

        Hi again,

         

        I have resolved my issue.

         

        For some reason one of my spreadsheets had unexpectedly added MANY additional blank columns!

         

        After deleting these columns my PowerBI refreshed as usual.

         

        I located and resolved the offending spreadsheet using PowerBI's "Transform data" and reviewing the columns for each "Navigation" step in each data source.

         

        Siggy