Metabase is powerful analytic tool which lets anyone learn and make informed business decisions from data. Metadata is targeted as a self service BI platform for business users without IT, Database or technical skill set. Using enhanced dataset metadata. When Power BI Desktop creates reports, it also creates dataset metadata in the corresponding PBIX and PBIT files. Previously the metadata was stored in a format that was specific to Power BI Desktop. The metadata used base-64 encoded M expressions and data sources. Power BI made assumptions about how that.
-->When Power BI Desktop creates reports, it also creates dataset metadata in the corresponding PBIX and PBIT files. Previously the metadata was stored in a format that was specific to Power BI Desktop. The metadata used base-64 encoded M expressions and data sources. Power BI made assumptions about how that metadata was stored.
Metabase Vs
With the release of the enhanced dataset metadata feature, many of these limitations are removed. PBIX files are automatically upgraded to enhanced metadata upon opening the file. With enhanced dataset metadata, metadata created by Power BI Desktop uses a format similar to what is used for Analysis Services tabular models, based on the Tabular Object Model.
The enhanced dataset metadata feature is strategic and foundational. Future Power BI functionality will be built upon its metadata. These other capabilities stand to benefit from enhanced dataset metadata:
- XMLA read/write for management of Power BI datasets
- Migration of Analysis Services workloads to Power BI to benefit from next-generation features.
Upgrade
Your reports will be automatically upgraded to the enhanced metadata format when you open them in the latest version of Power BI Desktop. If the report was saved with unapplied query changes, or there was an error during the auto-upgrade, then you will see a warning on the report canvas indicating that you still need to upgrade. Clicking 'Upgrade report' will apply any pending changes and upgrade the data model to the new format.
Limitations
Before enhanced metadata support, for SQL Server, Oracle, Teradata, and legacy HANA connections, Power BI Desktop added a native query to the data model. This query is used by Power BI Service data models. With enhanced metadata support, the Power BI service data model regenerates the native query at runtime. It doesn't use the query that Power BI Desktop created. In most cases, this retrieval resolves itself correctly, but some transformations won't work without reading underlying data. You may see some errors in reports that previously worked. For example, the error will say:
“Unable to convert an M query in table 'Dimension City' into a native source query. Try again later or contact support. If you contact support, provide these details.'
Metabase Power Bike
You can fix your queries in three different places in Power BI Desktop:
When you apply changes or do a refresh.
In a warning bar in the Power Query Editor informing you that the expression couldn’t be folded to the data source.
When you run evaluations when you open a report to check if you have unsupported queries. Running these evaluations can result in performance implications.
Next steps
Metabase Vs Power Bi
You can do all sorts of things with Power BI Desktop. For more information on its capabilities, check out the following resources: