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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors