Forum Discussion

juddmk's avatar
juddmk
Frequent Visitor
5 years ago
Solved

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

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 l...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.