AXForum  
Вернуться   AXForum > BI > BI Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 28.01.2021, 23:12   #1  
Blog bot is offline
Blog bot
Участник
 
24,592 / 822 (77) +++++++
Регистрация: 28.10.2006
msdynamicsworld: Power BI Insights: Infer sheet dimensions; DirectQuery; Fuzzy matches
Источник: https://msdynamicsworld.com/story/po...-fuzzy-matches
==============

Power BI bloggers share tips on loading problems with Power Query, creating DirectQuery models and fuzzy matches.

Solving loading problems with Power Query

Chris Webb shared his thoughts on a new Power Query feature released in December for Power BI Desktop. The InferSheetDimensions Excel.Workbook function can infer the value for certain cells from the worksheet itself in situations where the dimensions metadata is incorrect. Currently, this is only supported for Open XML files and not legacy Excel files.

On its docs page, Microsoft provides a much more detailed description of the new option with a section on how to troubleshoot issues where Power Query isn't loading all the data from the worksheet. He wrote:
Open XML format Excel workbooks (ie xlsx and xlsm format files) have some metadata (the “dimensions metadata” referred to in the docs) in them that acts as a kind of bounding box describing the range of cells in each worksheet that contain values. By default, Power Query uses this metadata when it gets data from an Excel worksheet – although not when it gets data from an Excel table or named range. Most of the time this metadata is reliable but in some cases, for example where an xlsx file has been generated by third-party software that has “export to Excel” functionality, it contains inaccurate information. This doesn’t affect Excel, which still loads the workbook, but it means that Power Query may not load all the data present in a worksheet. In these cases, setting InferSheetDimensions=true in Excel.Workbook causes Power Query to ignore the dimensions metadata and load all the data from the worksheet.

<h2>Using a Power BI dataset and local Excel file to create a DirectQuery model


Источник: https://msdynamicsworld.com/story/po...-fuzzy-matches
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 18:51.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.