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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.