cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lil_roro
Frequent Visitor

Direct Query December Update not working

I have recently installed the December 2020 update and enabled the new Direct Query functionality, however it appears the functionality is not working. I've attempting both with a connection to Azure Data Services and a connection to a PowerBI data set but in each case the option to 'Make changes to this model' in the connection details (bottom pane) is not present and I the 'Get Data' and 'Transform Data' menu options are disabled, just as it used to be in previous versions when connecting live. I have also attempted to work first with a local model and then connect to a PowerBI data set but receive the 'You cannot connect to a Live data source when already connected to a data source' error message. 

 

I'm using my organization account in PowerBI service to connect to the PowerBI data set. 

 

Perhaps I'm missing something very obvious and hoping someone might have the answer? 

8 REPLIES 8
parry2k
Super User III
Super User III

@lil_roro Hmm. I think at this point I will go to support and ask if this Azure Data Service is supported.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





yingyinr
Community Support
Community Support

Hi @lil_roro ,

What's the version of your Power BI Desktop? It is working well as I test it with the below version:

PBI Version.JPG

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @yingyinr - thanks for your message. I have the same version as you have shown installed yet when I try to connect to a PowerBI dataset I am getting the below message. Similarly, if I try to connect using a new file to Azure Analysis Services or a PowerBI dataset using a new file, as soon as I make the connection the Get Data menu is disabled - basically it is behaving exactly as it had in previous versions and I'm not getting the functionality where I can transform the data model or create a local model. Any ideas?? Is there something obvious I'm missing here that would otherwise prevent the functionality from working (I have already reviewed the December update article and can't find a solution there). 

lil_roro_0-1609760636381.png

 

yingyinr
Community Support
Community Support

Hi @lil_roro ,

Can you use DirectQuery to connect to any Power BI Dataset? According to the info refer in the blog provided by @parry2k , it is still waiting for some final Azure Analysis Services updates, and may not support use DirectQuery to connect to Azure Analysis Services currently...

Note that at the moment, we are waiting for some final Azure Analysis Services updates which are rolling out this week. You will be able to try this feature against Power BI Datasets, and support for connections to Azure Analysis Services will come by the end of this week.


Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
parry2k
Super User III
Super User III

@lil_roro there are for sure limitations, read at this post






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





lil_roro
Frequent Visitor

Thanks @parry2k  -I had already reviewed that article and it doesn't provide the answer to my query. 

 

parry2k
Super User III
Super User III

@lil_roro you need to turn this feature on in the preview, options.

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





lil_roro
Frequent Visitor

Hi @parry2k  - thanks for your input but I already did enable the feature in the Preview Options and restarted PowerBI but the functionality is not working. I'm thinking perhaps there is a limitation here I'm not aware of either due to my organization permissions or the type of connection I'm using. I understand it's not possible to connect to MyWorkspace PowerBI data sets, but I'm trying to connect live to a published data-set and as soon as I do this, the Get Data and Transform data menus are disabled. Any ideas?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors