Forum Discussion

southwood's avatar
southwood
Frequent Visitor
4 years ago

Error when trying to convert shared dataset to DirectQuery

I have a shared dataset using the default Live Connection but want to convert to DirectQuery to add additional data sources.  When I click the "Add a local model" button in the dialog box, we get the...
Need Help
southwood's avatar
southwood
Frequent Visitor
4 years ago

Thanks for the suggestions.  I did the update to the current version and checked the Preview settings, but still getting the same error.

KNP's avatar
KNP
Super User
4 years ago

Can you connect to that dataset from a new PBIX?

  • southwood's avatar
    southwood
    Frequent Visitor
    4 years ago

    yes, and I can create a new visualizion from it. The error pops when I try to add a new data source for additional data.

    • KNP's avatar
      KNP
      Super User
      4 years ago

      Yeah, I see what you're saying, I just picked one of my datasets at random and clicked the 'make changes...' and I got the same error as you.

      I tried a different dataset in a different workspace and I was able to make changes.

      Then I tried to add the original dataset back in and got this error...

       

      Something definitely seems to be wrong.

       

      There is this old post that seems to be a similar issue.

      https://community.powerbi.com/t5/Issues/DirectQuery-for-Power-BI-datasets-and-Analysis-Services-Error/idi-p/1556478

       

      I'll see if I can figure out any relationship between the issue and workspace/dataset I tested.

      • southwood's avatar
        southwood
        Frequent Visitor
        4 years ago

        wow ... thats's scary