SnowConvert AI: Power BI Repointing¶
SnowConvert AI provides a new option to redefine their Power BI connections to the migrated databases in Snowflake. This redefinition of connections is called repointing. Repointing is executed inside the SnowConvert AI migration logic and uses the migration context to identify and migrate correctly embedded SQL queries.
Please refer to the specific source language that your are repointing:
How to use it¶
Note
Notice that this feature only supports Power BI reports with the extension .pbit. Before starting, please save your reports to .pbit extension.
Locate the Power BI reports in a folder and apply restrictively the extension of a template .pbit.
In the SnowConvert AI app, add the path of the Power BI projects in the ETL-BI section.
Continue the migration steps as normally.
Reports: In the output folder you can review a ETL-BI report about the repointing transformation.
Access: In the output folder, you can review the “repointing_output” to access the Power BI repointing reports.
Execution: Before opening your reports, it is important to run all your migrated files in your Snowflake account. Otherwise, the object will not be retrieved because they do not exist in the Snowflake account. So, follow the next steps:
Run your migrated queries.
Open your Power BI report.
Add the Power BI parameters required:
SF_SERVER_LINK
,SF_DB_NAME
andSF_WAREHOUSE_NAME
. For more information, please review the following Power BI parameters documentation.Click on load and wait the report to retrieve the information.
Provide your account credential to Power BI app. In the case that you have Two-factor authentication, you may be asked to accept every request of connection from Power BI. Be aware that, there may be several pop-ups for authorization.
Review the ETL-BI report and fix every data entity with issues.
Refresh the data.
Support Insights¶
The current version supports:
Repointing of tables, view, and embedded SQL queries.
Maintain the remaining logic steps after the connection steps in the M Language (multiple lines).
Provides parameters inside Power BI to handle information correctly for Snowflake server link, warehouse and database name.
Convert queries saved as expression (when “Enable load” property has been disabled).
Renaming of columns based on related DDLs on the migration or by Power BI report references if DDLs are not provided.
Identification of views, if related DDLs are provided in the migration.
Notice that other connections from other sources rather than the selected in the migration settings are not being edited.
Considerations:
The schema name of the source connections are being used as the schema in the repointed connection. It is assumed that the Snowflake database objects were created under the same schema.
The database objects must be deployed in Snowflake before trying to open the repointed report.
If the column renaming step in the M Language is empty, it means that no information was found in the migration context or Power BI project references to create it.
Functions and procedures are not supported in connectors different from SQL Server and Azure Synapse, so these cases are not supported.
All found database connections related to the source language in the migration settings will be repointed and parameters will be added.
Troubleshooting¶
If the user does not enter the requested global parameters after repointing, the load of objects is not triggered by Power BI, so make sure to add the parameter information. If the user clicks on cancel and the reports do not load, then it is recommended to close and reopen the report.
If a visualization does not load, it may be because a column definition does not match the text case. Notice that the Snowflake connector from Power BI retrieves the entities and columns always in uppercase.
If you have issues with the credential cache, you can go to settings in Power BI and clear the connection to enter new credentials.
There may be problems with complex SQL queries after migration. These cases may require extra work to solve warning messages from the migration process (EWI - PRF - FDM).