Share via

Connection between Azure Analysis service and powerbi

Nazim Abdul Rahman 0 Reputation points
2023-09-30T05:43:35.3933333+00:00

Hello,

I'm attempting to establish a connection between Azure Analysis Services and Power BI in Direct Query Mode. However, I'm encountering a challenge where the storage mode in the model is fixed as default, and I'm unable to switch it to dual storage mode. Can anyone offer a solution for this issue?

Thanks,
Hamna K S

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
457 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Amira Bedhiafi 26,261 Reputation points
    2023-10-01T17:23:11.0533333+00:00

    In Model view, select the table whose properties you want to view or set. In the Properties pane, expand the Advanced section, and expand the Storage mode drop-down.

    Changing the Storage mode of a table to Import is an irreversible operation. After this property is set, it can't later be changed to either DirectQuery or Dual.

    You can know more here : https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.