Page Comparison

...

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:

1. No longer need gateway connection

2. No need for data flows

3. Direct control of security managed at the data level in snowflake both on rows and columns

4. All transformations will be visible in snowflake rather than multiple places in pbi eg. dataflow, dataset,

PBI Snowflake concerns voiced by the group:

1. If we are using direct connect mode on the snowflake data how will that affect performance?

2. Can we use AD groups for security in snowflake?

3. How will imbedded reports work with Snowflake.

4. How difficult will it be to transform the MS SQL queries into Snowflake queries with the syntax differences?

2/29/2024

• Questions/ Problems - user help

  • darshaun gateway refresh

• Eric Johnstone - PBI story

• dataflows and snowflake

2/15/2024

• Questions/ Problems - user help

• Power BI and Snowflake - awareness intro, how it can simplify Power BI

• User Training - Help is on the way - Mara Morrison an update on power bi training

• Power BI Product Manager Role, is this needed?

  • site license

  • capacity maintenance, performance

  • cost management

  • security audits - who has access to what? who has access what? ( team level, not central, could recommend best practice )

  • Site usage growth - Grows product usages maintains and monitors Key Product Indicators PBI usage metrics -

  • Tracks PBI artifact inventory and use of ( team level, not central, could recommend best practice )

  • version control ( team level, not central, could recommend best practice )

• PBI Source Control - Updates to Power BI Git confluence documentation

2/1/2024

Mark Norstedt will present version control on PBI. We will discuss pros and cons.

1/4/2024

Agenda

• questions from users -

  • Marsha Robertson connecting power bi to dev ops data for FMM project

  • Other questions?

• Questions from 12/7/23

• Source control

...