Change "Direct Query to AS" to SQL import

[Anonymous]

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 see on "Data source settings" that there is a connection to "DirectQuery to AS"

Before I had conection directly to SQL database

Do you know how can I restore the connection and power queries?

Thank you in advace

[ShirinArshadnia]

@Anonymous 

please share your example.

[ShirinArshadnia]

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]

Hi @ShirinArshadnia 

I know this.

My question is how to do it 🙂

Thank you

[Anonymous]

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]

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