...
https://ucsb.zoom.us/j/223753798
3/14/2024
Questions/ Problems - user help
Kara Nowell - how to get the gateway to connect to an alias
Snowflake and PBI
Discussion
The gateway connection string must match exactly to the connection used in the dataset. All data sets will have to be updated. After deploying to the PBI service > goto settings > select PBI Gateway
Snowflake Archana Pandey demonstrated the PBI connecting to a snowflake table. Data from allall UCSB datasources will be loaded into raw, refined to integrated and further refined to presentation. PBI will connect to presentation. Advantages are:
No longer need gateway connection
No need for data flows
Direct control of security managed at the data level in snowflake both on rows and columns
All transformations will be visible in snowflake rather than multiple places in pbi eg. dataflow, dataset,
PBI Snowflake concerns voiced by the group:
If we are using direct connect mode on the snowflake data how will that affect performance?
Can we use AD groups for security in snowflake?
How will imbedded reports work with Snowflake.
2/29/2024
Questions/ Problems - user help
darshaun gateway refresh
Eric Johnstone - PBI story
dataflows and snowflake
...