Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dashboard keeps on loading "creating connection in model"

I try to refresh my dashboard but the pop-up screen keeps on loading "creating connection in model".  Cancelled it multiple times, restarted PowerBI multiple times, tried it in the desktop windows-ap...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Please check the dataset loaded into desktop, if it contains empty columns (with [null] values), please remove them, ensure that only needed columns are loaded. Then, try to refresh again.

     

    Besides, if error persists, please uncheck the following highlighted options in Power BI Desktop and then refresh your data model.

     

    Best regards,

    Yuliana Gu

     

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please check the dataset loaded into desktop, if it contains empty columns (with [null] values), please remove them, ensure that only needed columns are loaded. Then, try to refresh again.

 

Besides, if error persists, please uncheck the following highlighted options in Power BI Desktop and then refresh your data model.

 

Best regards,

Yuliana Gu

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yulgu-msft, 

 

Thanks for the solution! It seemed that PowerBI saw 16,000 extra columns which weren't filled with data.. I manually deleted the columns which resulted in a good working dashboard again! 

 

One extra question: For what reason does PowerBI detect extra columns which aren't filled in the original Excel? Is there a way to avoid this? 

 

Many thanks! 

 

Johan