Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 51 | |
| 42 | |
| 34 | |
| 33 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 125 | |
| 100 | |
| 80 | |
| 61 |