Power BI Failed to save modifications to the server

[Anonymous]

Please help me out and need any questions please let me know

[Daryl-Lynch-Bzy]

@Anonymous - Do you mean that you are using Power Query within Excel?  Not the server.   If this is the case, are you using 32-bit Excel.  Excel has a 1.5GB limit, so you are trying to import to much data.  Try importing each query individual into a separate Excel session to see how big the data really is.  

[Anonymous]

The data is getting imported from SQL Server and If I am running between the tenure like 1st Dec to 15th Dec it is running fine and we start doing from 16th Dec it will throw an error like the above screenshot attached.

[Daryl-Lynch-Bzy]

@Anonymous - sorry there is just too much data.  If you cannot change from 32-bit Excel to 64-bit You really need to reduce the amount of data returned.  Try remove necessary columns, and group by to remove unnecessary rows.  If that does not work, each individual query will have to be exported in separate Workbook and possible separate Excel application sessions.

[Daryl-Lynch-Bzy]

Hi @Anonymous - Could you please provide more detail about what you are doing.  For example, it this Dataflow?

Many thanks

Daryl

[Anonymous]

The Data flow from MS SQL to Excel and the destination is Power BI.

[Daryl-Lynch-Bzy]

@Anonymous - did you mean "or" i.e. SQL or Excel  into the Dataflow?