Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Change "Direct Query to AS" to SQL import

Hi,   When I download file from PowerBI Service I lost my Power Queries This is how it looks before I have a lot of transformation there and I would like to restore them I can ...
Need Help
ShirinArshadnia's avatar
ShirinArshadnia
Helper II
2 years ago

hi Anonymous 

when you change your data source you can see the queries and all the steps in that source,you should use the left panel to navigate from sources and queries.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ShirinArshadnia 

     

    I know this.

    My question is how to do it 🙂

     

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      Thank you for reaching out to us with your problem. It seems like you’re trying to restore Power Queries and restore the data source from â€œDirectQuery to AS” to a direct SQL database connection in Power BI. And they are different data source type. If the data from these two data sources have the same data structure, you can follow the below steps to get it:

      1. Open the Power BI file: Open the Power BI file where you want to restore the Power Queries.

      2. Go to Query Editor: In the Home tab, click on ‘Edit Queries’ to open the Power Query Editor.

      3. Change Data Source: In the Power Query Editor, you can change the data source from SQL database to “DirectQuery to AS”. To do this, go to ‘Home’ > ‘Data Source Settings’. In the window that opens, you can change the data source.

      How to Change Data Sources for Existing Power BI Reports - Iteration Insights

      How to Change Data Source in Power BI - Zebra BI

      4. Restore Power Queries: If you have a backup of your Power Queries, you can restore them in the Power Query Editor. Go to ‘Home’ > ‘Advanced Editor’, and replace the existing M code with your backup M code.

      Advanced Editor

      Best Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,

         

        Thank you for your reposne

        Unfortuneately id did not help me.

         

        I changed the data source but it did not restore my tables. It has created a new one.

         

        And I do not have a backup query I want to restore it

         

        If you not how to solve it pelase tell me 🙂

         

        Thank you in advance