Unable to save document

[admin_xlsior]

Hi,

Today I cannot save my Power BI due to this error :

There is also another error if I try to "Save As" to another location ->

I'm using Direct Query to SQL Server, and the access is fine. Even I still can go to Recent data sources and get another table (for testing only)

It already make me loose my half day working, since it cannot save then I have to End task from Task manager, but open the recover file also throw me error which not even success to open anything->

By checking through my SQL Server Management Studio, also nothing wrong and I still can access my data.

Has someone encounter this?

I restarted my PC and try open again with no luck, everytime I save it throw me all those error.

Please help,

Thanks.

[v-frfei-msft]

Hi @admin_xlsior ,

Please update your Power BI desktop and disable the option and check again. 

[admin_xlsior · Accepted solution]

Hi,

I found the problem. It turned outs because I make a reference with a table in which the table is a Direct Query.

So lets say I have Date (dimension) gets from SQL Server, and still using Direct Query method.

Then I create new table refer to date, Date2 = Date

I tried to redo all over again, try and error, until it was passed when I'm not using table reference instead I Get Data again one more time for my Date2 table.

Thanks.