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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 26 | |
| 24 | |
| 23 | |
| 16 |
| User | Count |
|---|---|
| 54 | |
| 49 | |
| 41 | |
| 32 | |
| 22 |