Догађаји
Поwер БИ ДатаВиз Светско првенство
14. феб 16 - 31. мар 16
Са 4 шансе за улазак, можете освојити конференцијски пакет и стићи до ЛИВЕ Гранд Финале у Лас Вегасу
Сазнајте вишеОвај прегледач више није подржан.
Надоградите на Microsoft Edge бисте искористили најновије функције, безбедносне исправке и техничку подршку.
In the Data Types Gallery in Excel, users can find data from featured tables in your Power BI semantic models. In this article, you learn how to set tables as featured in your semantic models. These tags make it easier for users to add enterprise data to their Excel sheets. Here are the basic steps for setting and sharing featured tables.
In Power BI Desktop, go to Model view.
Select a table, and set Is featured table to Yes.
In the Set up this featured table dialog box, provide the required fields:
Савет
Start the description with "Featured table" to help Power BI report creators identify it.
After you publish or import the semantic model to the Power BI service, the featured table appears in the Excel Data Types Gallery. You and other report creators can also create reports built on this semantic model.
In Excel:
The Data Types experience in Excel is similar to a lookup function. It takes a cell value provided by the Excel sheet, and searches for matching rows in Power BI featured tables. The search experience has the following behaviors:
Row matching is based on text columns in the featured table. It uses the same indexing as Power BI Q&A capability, which is optimized for the English-language search. Searching in other languages might not result in accurate matches.
Featured tables use Power BI Q&A indexing when users query data in those tables. For more information, see How does indexing work with Q&A.
Most numerical columns aren't considered for matching. If the Row label or Key column is numeric, they're included for matching.
Matching is based on Exact and Prefix matches for individual search terms. A cell’s value is split based on spaces or other whitespace characters like tabs. Then each word is considered a search term. A row’s text field values are compared to each search term for Exact and Prefix matches. A Prefix match is returned if the row’s text field starts with the search term. For example, if a cell contains “Orange County”, then “Orange” and “County” are distinct search terms.
Here are the current limitations:
The integration is available in Excel in the current channel.
Featured tables in Power BI semantic models that use the following capabilities aren't shown in Excel:
Excel shows only data in columns, calculated columns, and measures defined in the featured table. The following aren't provided:
Power BI returns at most 100 row suggestions for each cell.
Some symbols aren't supported.
Setting or updating the featured table isn't supported in the XMLA endpoint.
Changing the Table name, Row Label, or Key Column in the featured table may impact Excel users with linked cells to rows in the table.
Excel shows when the data was retrieved from the Power BI semantic model. This time isn't necessarily the time that the data was refreshed in Power BI, or the time of the most recent data point in a semantic model. For example, say a semantic model in Power BI was refreshed a week ago, but the underlying source data was a week old when the refresh happened. The actual data would be two weeks old, but Excel would show data retrieved as the date/time at which the data was pulled into Excel.
See Considerations and limitations in the article "Access Power BI featured tables in Excel" for other Excel considerations.
Догађаји
Поwер БИ ДатаВиз Светско првенство
14. феб 16 - 31. мар 16
Са 4 шансе за улазак, можете освојити конференцијски пакет и стићи до ЛИВЕ Гранд Финале у Лас Вегасу
Сазнајте вишеОбука
Модул
Transcend data analysis together with Power BI and Excel - Training
This module introduces potential ways that people can use Excel and Power BI together. Power BI is a great tool for telling a story through visuals; occasionally, it's beneficial to use Excel for analysis. Excel can make a connection to a Power BI dataset, enabling you to analyze the data by using PivotTables.
Цертификација
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.