Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Beginning yesterday, I'm getting an error "We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you ahve permission to access them."
This error pops up when opening my PBI file. The file is only connected to excel files on my desktop. This is not a published file. I'm the only one accessing it from this location. I haven't changed anything in the connections that last couple days. It seems like some kind of update to PBI got pushed to my computer, but hard to tell.
Anyone know what to do with this error? I can't do anyting in PBI right now, and am supposed to present/drive a meeting today.
Hello you could solve? The same thing happens to me!
Hi @BrianVT ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @BrianVT ,
You may upgrade the Power BI Desktop to the latest version 2.81.5831.821. Then reopen the pbix file, go to File-> Options and settings-> Data source Settings, click Clear Permission for the data source that you don’t need.
For the broken visuals, you may check if there are related incorrect or missing columns or measures in Fields pane.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So, here is something really strange to add. A couple days ago, in Microsoft Outlook, I selected an option to encrypt all outgoing messages (requirement for work; either do that, or check that on every message I send). Well, I just decided to turn that off on a whim, restart, and I was able to get into PBI without the error popping up. No idea how they're related, unless there is just some security interaction on my computer causing issues.
However, even though the error isn't coming up anymore, I see some issues in my reports in my file. Like some of the slicers are saying they're broken, and I have to go delete them and make a new one. That is working in some cases, but not all. Really strange.
2.73.5586.984 64-bit (September 2019)
This is a Govt laptop that can only get pushed stuff (can't install on my own)
@BrianVT I have seen this issue, can you make sure enhanced metadata under preview is turned off.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I don't have those same options under Preview Features. Only these six:
Shape map visual
Spanish language support for Q&A
New web table inference
Incremental Refresh Policies
Enable Q&A Live Connect
Personalized visualizations pane
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |