https://community.databricks.com/t5/data-engineering/connecting-power-bi-to-delta-share-error-on-data-retrieval/m-p/49041#M28457 <P>Hi everybody,</P><P>sharing data with an access token and Databricks Connector works fine in Power BI (desktop). Now we wanted to switch to Delta Sharing.</P><P>We setup a delta share to distribute data via open share to anyone outside our organization. Unity Catalog, Delta Share and recipient are up and running.</P><P>We shared the endpoint information and bearer token with the actual recipient who started Power BI using the Delta Sharing connector. The Power BI Navigator shows the correct table to share.</P><P>Problem:</P><P>Clicking on data preview or trying to load data ends up in an error (unexpected error concerning ParquetSharp).</P><P>I’m suspicious about myself missing an essential part? How do I tell the Delta Share which cluster to use/spin up, when the client triggers the data request in Power BI via Delta Sharing?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pb_error.jpg" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4380iD477F25DE34CFAF2/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="pb_error.jpg" alt="pb_error.jpg" /></span></P> Thu, 12 Oct 2023 16:49:45 GMT Gobo 2023-10-12T16:49:45Z https://community.databricks.com/t5/data-engineering/connecting-power-bi-to-delta-share-error-on-data-retrieval/m-p/49041#M28457 <P>Hi everybody,</P><P>sharing data with an access token and Databricks Connector works fine in Power BI (desktop). Now we wanted to switch to Delta Sharing.</P><P>We setup a delta share to distribute data via open share to anyone outside our organization. Unity Catalog, Delta Share and recipient are up and running.</P><P>We shared the endpoint information and bearer token with the actual recipient who started Power BI using the Delta Sharing connector. The Power BI Navigator shows the correct table to share.</P><P>Problem:</P><P>Clicking on data preview or trying to load data ends up in an error (unexpected error concerning ParquetSharp).</P><P>I’m suspicious about myself missing an essential part? How do I tell the Delta Share which cluster to use/spin up, when the client triggers the data request in Power BI via Delta Sharing?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pb_error.jpg" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4380iD477F25DE34CFAF2/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="pb_error.jpg" alt="pb_error.jpg" /></span></P> Thu, 12 Oct 2023 16:49:45 GMT https://community.databricks.com/t5/data-engineering/connecting-power-bi-to-delta-share-error-on-data-retrieval/m-p/49041#M28457 Gobo 2023-10-12T16:49:45Z https://community.databricks.com/t5/data-engineering/connecting-power-bi-to-delta-share-error-on-data-retrieval/m-p/49046#M28458 <P>Hi everybody,</P><P>for anybody running into the same issue.</P><P>It is a bug in the current Power Bi version (2.121.644.0). I reverted back to the April release (2.116.404.0), which does work as expected.</P><P>&nbsp;</P> Thu, 12 Oct 2023 19:45:33 GMT https://community.databricks.com/t5/data-engineering/connecting-power-bi-to-delta-share-error-on-data-retrieval/m-p/49046#M28458 Gobo 2023-10-12T19:45:33Z