Error with Converting from Live Connection to Direct Query in Power BI Desktop

[juddmk]

I am an admin of a premium workspace and publish various reports to the workspace that feeds a published app. I want to connect to a published dataset (Financials) in the workspace and can create a live connection in a Power BI Desktop file. However, when I try to "Make changes to this model" by changing from live connection to Direct Query, I get the following error: 

I own the Power BI Desktop file that feeds the dataset, I am an admin in the workspace, and I can create Direct Query connections into all of the other datasets in my group's premium workspace. Is there a setting that I need to change in the source desktop file or in the workspace that will allow me to connect to this dataset through Direct Query?

[v-xiaoyan-msft · Accepted solution]

Hi @juddmk,

I'm sorry I can't reproduce your problem, but I've found others in the issue forum with similar problems to yours. Here

The workarounds suggested are:

Check the integration settings “Allow XMLA endpoints and Analyze in Excel with on-premises datasets “,it must be enabled in the admin portal.

If it is turned off, it will also cause this problem.

If it does not work:

Please try to create the Direct Query connection to Power BI dataset in a Shared Capacity workspace, It requires a Pro license to consume the report.

Or

Create an import dataset in a premium capacity workspace that loads the data from the original data source and refresh it regularly.(This would allow non-pro users to consume the report.)

I will give you feedback when this issue is updated.

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.