cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors