Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Newbie: DirectQuery on SSAS and DirectQuery on PowerBI

Hi So I am new to SSAS - built model in Tabular and its really slow to open but i can query this with no performance issue via SSMS or analyze in excel locally. However when using PowerBI to visuali...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Anonymous I am not aware of any way to accomplish this. Any mucking around with the pbix file results in a corrupted file... There is a connection file in Live Query that is not there for a PBIX file that was imported into, but all my test cases have failed when trying to switch over. 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

HI there

My Power Bi Desktop is April release. I just realised that there are differences between Live Connection and Direct Query.

I think my real question is how to change from Live Connection to Import but someone said its impossible :( Is this correct?

 

I dont want to re-do my dashboard but it seems to be the only way to go :(

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Anonymous I am not aware of any way to accomplish this. Any mucking around with the pbix file results in a corrupted file... There is a connection file in Live Query that is not there for a PBIX file that was imported into, but all my test cases have failed when trying to switch over.