topic Re: Update Snowflake's datasource advanced options in Developer

Update Snowflake's datasource advanced options

Anonymous — Mon, 18 Jul 2022 21:50:32 GMT

We use Snowflake as a data source for our reports and there is a need to programmatically update a role (not the user) that PBI uses to connect to the database.

It seems that PBI uses some kind of extension to access the Snowflake database. Though you can edit that role in the Query editor of PBI Desktop, where the source is defined, I wasn't able to see or edit the same information view API calls. Accessing datasource through the gateway endpoints I can see the server and warehouse values, but there is nothing in regard to advanced options there.

Moreover, I need to do it in .NET code...

Re: Update Snowflake's datasource advanced options

v-chenwuz-msft — Thu, 21 Jul 2022 08:22:16 GMT

Hi @Anonymous ,

Hi ,

Maybe you can try edit in power query editor advanced editor.

Or you can try this snowflake-connector-net in .NET code.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Update Snowflake's datasource advanced options

Anonymous — Thu, 21 Jul 2022 17:08:44 GMT

Yes, you can edit the source in a query editor, as I stated in my post.

Could you please explain how snowflake-connector-net might be used as a data source for the pbix report?