Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I'm having a problem in which not even the microsoft consultors from my country were able to help me into solving. Does anyone has any ideia how to solve this? Basically when I'm trying to open a powerbi file this message appears, not enableling me to work. Coul anyone help me? This is the message that appears:
That translates to:
Error to sae the modifications to the servers. Error returned "The column TR_FAT_06[FATPGT] does not exists or doesn't have a relation with any table avaible on the actual context. The column TR_FAT_06[FATVEN] does not exists or doesnt have relation with any table avaible in the actual context. Login failed for user ".. An exception has been generated through the interface of the IDbConnection. It was not been able to do a connection to the origin of data with the name "............................ lots of things".
This link has the details powerbi sent me of the error link!
these questions were probably already asked, but they're missing in your post:
1) is it Direct Query or import?
2) if you create a new Power BI file connecting to that database, does it work fine?
3) based on the error description there is some discrepancy in the TR_FAT_06 table - does it exist in the server?
4) if yes - does it have columns FATVEN and FATPGT?
5) if you published the report in the service - can you download the copy from there and try to open it?
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 37 | |
| 29 | |
| 24 |