Access to dataset

[Adrian5017]

Hi,

I want to download dataset from my organization and work with it offline, but when I want to edit something in query I don't have access. Is it possible to edit PowerQuery without access?

[Mikelytics]

Hi @Adrian5017 

When you download a file and want to refresh the data offline you have to provide the credentials in the initial load. ANd the refresh is a prerequisite for editing the Power Query steps. 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Adrian5017]

Yes, but I don't want to refresh. I need to edit PowerQuery on dataset without access to database. 

[Mikelytics · Accepted solution]

@Adrian5017 

okay, but unfortunately this is not possible folllowing standard approaches.

There is one workaround which might be applicable for you. 

For example with DAX Studio you can export the data of the file into csv or to a local database. Then you can change the connection of the file to the exported data and make your changes. In the end you recreate the connection to the real database and then publish the dataset from where you can do the refresh. But as youc an see the switching between different data sources can end in much effort.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn