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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Mimi_Ibrahim
Helper I
Helper I

Unable to connect after clear permission

Hello, 

 

I recently facing an issue with one of my dashboard which I was asked to clear the permission by the support team. This unfortunately creates another problem. I'm no longer able to connect to the database via ODBC connection. It is now stuck at "Creating connection in model..." and nothing happen. 

I have set up the credentials using Windows credentials (like previously) but still nothing. 

Please can someone help?

 

Thank you.

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@Mimi_Ibrahim  Which version of Power BI are you using? The Sept-Oct releases show 'Creating Connection in Model' for ages, but if you are patient will eventually load the data. This will be fixed with Nov update or you can revert back to Aug release if you still have it.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

5 REPLIES 5
AllisonKennedy
Super User
Super User

@Mimi_Ibrahim  Which version of Power BI are you using? The Sept-Oct releases show 'Creating Connection in Model' for ages, but if you are patient will eventually load the data. This will be fixed with Nov update or you can revert back to Aug release if you still have it.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Hi @AllisonKennedy,

 

I'm using the latest one downloaded today (uninstalled and reinstall). Unfotunately I've deleted the older PBI desktop setup when I clean up my folders recently 😞

Do you know where I can get the older version? 

 

I've been waiting since morning but no luck with the data load. Will wait for another 2 - 4 hours (If I have the patience!

 

Many thanks for your prompt reply. 

 

@Mimi_Ibrahim  I have saved some older versions here you can try: https://excelwithallisonmvp.sharepoint.com/:f:/s/Training/Ek4sCJaik_1Lnz9QWRuKcdkBMCuNq_GGJu-myiwXIm... 

 

I'm just copying over the August version now, so you may need to check in an hour if it's not there the first time you look. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Many thanks @AllisonKennedy 👍

You're very welcome!


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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