Forum Discussion
failed to bind the data gateway
Hi all, We're trying to set up a PBI Direct Query report connected to Azure Managed Instance SQL Server. Due to company policy we have to use gateway allow connection with alias service user. ...
When using Import from same source and with same Gateway - issue is resolved.
However the report weighes ~2GB on Import so it's not viable solution.
No one from Microsoft support here to address this unknown issue?
Hi Anonymous ,
Yes. There is a 1GB limit on the size of the data source in import mode. My suggestion is whether it is possible to do further compression of the data source and optimize the model. Or change to direct query mode, which has no size limit on data source.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.