<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionprops ] failed in the evaluation of <p> Microsoft Windows ?ODBC ?????????????CData ODBC Drivers ?Microsoft Power BI ???????????????????????????????????????CData ODBC Driver for [service] ?Power BI ?????????[datasource] ??????????SQL ????[datasource] ?Power BI Designer ?????????????????????????????????????????[datasource] ?????????????????????[datasource] ????????????????????????ODBC driver ????Microsoft Power BI Designer ?[datasource] ??????????????????????????????? </p> <h2>?????????????????</h2> <p> [datasource] ??????????????????????[Editing]??????????????????? </p> <ol> <li><p> ?????????????????????????(DSN)???????????????????? </p> <p> ?????????????????: </p> <p> [extraconnectionprops] </p> <p> DSN ???????Microsoft ODBC ???????????????????????????????????????????????? Microsoft ODBC ????????????????????DSN ??????????????????????????????????????? </p> </li> <li> Power BI Designer ?????[Get Data]?????????Power BI Designer ?PowerBI.com ?????????[??????]????????????[Power BI Designer]????????? <li> SQL ???????????????????[ODBC Query]?????????[Navigator]?????????1?????????????????????????[ODBC Tables]????????? <li>ODBC ??????????????????????????????????????????DSN ???????????: </p> <code>Provider=;Persist Security Info=False;DSN=[company_name] [rootadoname] Source</code> <i>Note</i>:?????????????????????.NET OLE DB Provider ??????"Provider=" ??????? <li> SELECT ?????????????????????????????????SQL ??????????????????[extable] ?????????????: <code> SELECT * FROM [extable] </code> <img src="../articles/odbc-power-bi-designer-1.png" title="The DSN to your data source and the SELECT statement to use to import the data. (Salesforce is shown.)"/> </li> </li> <li> ????[Query]??????????[Report]????????????????????????????????????[Fields]?????[Report]??????????????????????????????????[extable] ??????[excol#1] ????????????Power BI Designer ????????measure ????????: <img src="../articles/odbc-power-bi-designer-2.png" title="A bar chart showing Opportunity Names and Amounts from Salesforce."/> <p> [Home]??????????????????????????????????????????????? </p> <p> ???????????????sort ???????????????????????????????????????????????? </p> <p> ?????????????????????????????????????????????????????????????????????????????;??????????????????????????? ????????????????????????: </p> <img src="../articles/odbc-power-bi-designer-4.png" title="A highlighted opportunity in a pie chart. (Salesforce is shown.)"/> <p> ????????????????????????????????????????????[Fields]???[Filters]???????????????????:??????????[Filters]????????????????????????????????????? </p> <img src="../articles/odbc-power-bi-designer-3.png" title="Opportunities filtered by Name values. (Salesforce is shown.)"/> </li> </ol> <p> [Refresh]?????????????????????????? </p> <h2>[service] [datatype] ?????Power BI ???????</h2> <p> ODBC ????????????????????PowerBI ??????????????????????????????????????PowerBI.com ???????[Get Data]>[Files]???????Power BI Designer ???????Excel ???????????????????[Reports]????????????????????????</p> <h2>??????????????????</h2> <p> Power BI Personal Gateway ??????????????????????????????????? ??????????????????????Personal Gateway ????????????????Personal Gateway ODBC DSN ??????: </p> <ol> <li>??????Power BI ????????? <li>[Dataset]??????[service] Dataset ?????????? <li>[Schedule Refresh]????????? <li>???????[Settings]??????[Manage Data Sources]??????????[ODBC]??????[Edit]????????? <li>[Authentication Method]?????[Anonymous]???????[service] ????????DSN ???????????????? </ol> <p> Personal Gateway ????????????????????????????????</p><p>??????????????[Schedule Refresh]???????[Keep Your Data Up-To-Date]??????[Yes]???????????????????[Apply]????????? </p> <p> ??????????????[Datasets]??????[service] dataset ???????[Refresh Now]????????? </p> <img src="../articles/odbc-power-bi-designer-5.png" title="The uploaded Power BI report. (Salesforce is shown.)"/> </page>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/ponparemall-odbc-power-bi-designer.rst