The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Power BI Report Builder is not able to connect to Snowflake via an ODBC Connection when using the Power BI Service. However, It is able to connect to the database in the following cases:
On the "Show Lineage" page, the Data Source just shows unable to connect without any additional error info.
Upon opening the report, it just shows an error saying Unable to render the report. Screenshot attached below.
Hi @sanket-servian ,
This specific error message is associated with not setting the correct Gateway setting in the report's settings page. If set correctly, the report will either render or provide another error message if failing to render.
Best regards.Community Support Team_Caitlyn
Hi @v-xiaoyan-msft , Thanks for the response. I am able to connect to the database by configuring an On Premise gateway. However, I would prefer for the paginated reports to access the database without the need of an On Premise gateway similar to how it works for the regular PBI reports.
Also looking at the gateway permissions for this paginated report, looks like I can't disable the "use on premise gateway" flag.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.