Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
User | Count |
---|---|
123 | |
76 | |
63 | |
50 | |
50 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |