Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power Platform Dataflows DirectQuery mode stopped working with May 2023 and June 2023 Desktop update

Since upgrading Power BI Desktop to May 2023 version, all Power Platform Dataflow connections using DirectQuery or Dual mode have failed to refresh. The same issue persisted when Power BI Desktop was upgraded to June 2023 version 2.118.621.0 64-bit.

Attempts to connect to the dataflow also show that DirectQuery is not possible even though the dataflow has been set with enhanced compute engine turned ON in the workspace.

This issue also doesn't seem to be present when trying to connect using Power BI dataflows (Legacy), but there are other complications using the legacy connector which impedes the reversion to using the legacy connector.

 

brandonyeo_1-1687393053517.png

brandonyeo_2-1687393521910.png

brandonyeo_4-1687393754110.png

 

The refreshes were working prior to the May and June updates and are still working when the refresh was run on a colleague's Power BI Desktop that is still on the April 2023 version.

The dataset that is published on Power BI Service continues to refresh without any issues as well.

Status: Needs Info

Hi @brandonyeo 

If you roll back to the April release and use DirectQuery or Dual mode to connect to Power Platform Dataflow, you won't get the error reported, right?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @brandonyeo 

If you roll back to the April release and use DirectQuery or Dual mode to connect to Power Platform Dataflow, you won't get the error reported, right?

 

Best Regards,
Community Support Team _ Ailsa Tao

brandonyeo
Regular Visitor

Hi Ailsa @v-yetao1-msft ,

 

Tested with the latest patch 2.118.828.0 64-bit (June 2023) with the same results as initially posted.

 

I've rolled back to Apr 2023 version 2.116.966.0 64-bit.

The dataset is now able to be refreshed without the DirectQuery issues.

However, Power Platform Dataflows is not present as a data connection, only the legacy Power BI dataflows

 

brandonyeo_0-1687741818563.png

 

Regards,

Brandon

brandonyeo
Regular Visitor

Hi @v-yetao1-msft ,

 

Are there any updates to this issue?

 

Brandon

nk-frk
Regular Visitor

I would also like to know when this will be fixed.  We are using the August release and the problem still exists.

Thanks,

Nelson