Forum Discussion

strongman_pbix's avatar
strongman_pbix
Regular Visitor
1 year ago
Solved

Changed Table from DirectQuery to Import in Enterprise Model, but SSMS still picking up as DirectQue

Hello,

 

I have performed the following steps;

 

1) Changed table from DirectQuery to Import mode in our desktop enterprise model

2) Utilized ALM toolkit to push this change to our dataset

 

However it seems like no matter how many times I "successfully" push from ALM - it still shows this table as DirectQuery in our Dataset?

 

Would my next step be to attempt to publish the model or should I consider other options?

 

  • Self-solved, I needed to process the table in SSMS. Please feel free to close the thread 🙂

2 Replies

  • Self-solved, I needed to process the table in SSMS. Please feel free to close the thread 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi strongman_pbix ,

       

      Thanks for sharing, this will help people with the same question. You can accept your answer as the solution to close the thread.

       

       

      Best regards,

      Mengmeng Li