March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to Solution.
@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.
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
@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.
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.
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
You're very welcome!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |