MSBI Tutor

Connectors and driver changes   For the following connectors, Power BI/Fabric will move away from the current embedded ODBC drivers and toward the replacement drivers (primarily ADBC). Databricks: Simba Spark ODBC Driver → Databricks ADBC Driver Dremio: Simba Drill ODBC Driver → FlightSQL ADBC Driver Google BigQuery: Simba Google BigQuery ODBC Driver → BigQuery ADBC Driver Hive: Simba Hive ODBC Driver → Deprecated Impala: Simba Impala ODBC Driver → HiveServer2 ADBC Driver Snowflake: Simba Snowflake ODBC Driver → Snowflake ADBC Driver Spark: Simba Spark ODBC Driver → HiveServer2 ADBC Driver   Who’s impacted You are impacted if you use any of the connectors in the previous list and meet one of the following conditions: You haven’t explicitly specified an implementation for the connection Your organization wants centralized control over whether ADBC or ODBC is used by default.   This default behavior is intended to apply anywhere a connection is created (e.g., semantic model...

Power BI tenant migrations have shifted from a niche topic to a regular field conversation, usually triggered by an acquisition, divestment, data residency requirement, or overdue modernisation. This post complements the official Microsoft Learn documentation on Power BI tenant migration patterns and strategies . While the documentation covers the end-to-end process, this post focuses on how to decide if a tenant migration is the right choice—and the trade-offs to evaluate before committing. Across most customer engagements, one principle seems to hold true: tenant migration is typically a trade-off between potential gains and added complexity. This post covers common triggers, migration types, key risks, and scenarios where the benefits may justify the effort. The goal is to help you weigh that trade-off before the project gathers momentum of its own Why we are seeing more tenant migration requests Over the past year, there has been an uptick in tenant migration conversations. Most fa...

Migrate SSRS reports to Power BI Manually 1.     Open the report server portal that contains the reports you want to migrate. http://localhost/Reports 2.     Download each report definition, saving the .rdl files locally. 3.     Open  the latest version  of Power BI Report Builder and connect to the Power BI service using your Azure AD credentials.   4.     Open each report in Power BI Report Builder, and then:   5.     Verify all data sources and datasets are embedded in the report definition, and that they're  supported data sources . 6.     Preview the report to ensure it renders correctly. 7.     Select  Publish , then select  Power BI service .   8.     Select the workspace where you want to save the report.   9.     Verify that the report saves. If certain feat...