Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Analyst-Rene
Frequent Visitor

DirectQuery to Dataset Issue

I started off connecting to various sources (SharePoint Online lists and Excel), months agos. They are all import, and I could publish my report. I added a DirectQuery to Azure DevOps through Advanced Editor in Power Query Editor and I still had no issues in publishing my report. I then added DirectQuery to a Power BI Datasets, using the Get Data option in Power BI Desktop BUT now when I try publishing, I get the following message:

RenePro_0-1674729563274.png

 

My changes are not applied in the Workspace. Going to the service/my dataset that exists in a shared workspace I created, as I have access to create workspaces – I see the following:

RenePro_1-1674729563279.png

 

I tried manually refreshing the dataset and then got this message

RenePro_2-1674729563286.png

 

I have no issues in Power BI Desktop and I can refresh, so assume the online service is unable to refresh the dataset. So, I had a look online and found this guide Using DirectQuery for live connections, showing exactly what I am trying and that you can add this type of connection but that “Using DirectQuery for Power BI datasets and Analysis Services requires your report to have a local model.”. The issues I know face is that I do not have this option.

What the guide says

RenePro_3-1674729563292.png

 

What I see in my report, I do not have ‘Make changes to this model’

RenePro_4-1674729563293.png

 

I found another article, where you could be able to set the storage mode but for me, the option is greyed out

What I should see

RenePro_5-1674729563298.png

 

What I see for DirectQuery to Power BI Dataset tables, the options is greyed out and I cannot change it

RenePro_6-1674729563299.png

 

This is also not changeable

RenePro_7-1674729563300.png

 

There are 3 shared Workspaces and I have admin access to be able to create shared workspaces. I am an admin on each of them so have full access to the datasets. I am the publisher of on one of the Datasets.

 

Would appreciate it if anyone could let me know if they have faced this issue and if they managed to find a solution. According to the guides above, this should be possible.

 

I have posted, asking for help but one of them is closed with no real resolution and the other is old with no updates:

External

https://community.powerbi.com/t5/Service/This-dataset-includes-a-dynamic-data-source-Since-dynamic-d...

https://community.powerbi.com/t5/Desktop/Can-t-Make-Changes-to-Model-After-Connecting-to-Dataset/td-...

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.