Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
mamsteroonie's avatar
mamsteroonie
Icon for Helper I rankHelper I
3 years ago

This is the way it used to be for us, but they did change it to only require viewer permission a little while ago.  Maybe this is only for premium licensing?  we have premium.  But we don't have to add them as a build access anymore to view a report that is using direct query for power bi dataset.  Now, if they want to analyze in excel and build off the dataset, then they need build access.

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Hello FraukjeC , thanks for checking in! mamsteroonie is right, we changed the required permissions for Premium/PPU to just require Read permissions for viewing a report. Right now for Pro you still need Build. We are working on aligning that to Premium/PPU but it is taking longer than expected. 

  • FraukjeC's avatar
    FraukjeC
    Frequent Visitor
    3 years ago

    Hi jeroenterheerdt and mamsteroonie, thank you both for your information! We are indeed aware that within Premium/PPU licencing this issue is resolved. However, we have invested majorly in taking our full organisation to the next data-driven level by providing Power BI Pro licenses for all (5000+) employees only one year ago, so for us currenlty moving on to Premium/PPU licencing is not an option. 

     

    jeroenterheerdt I feel very optimistic hearing that Microsoft are actively working on removing the Build limitation for Pro users. This could mean that simply 'wait and work with the current limitation' might be a valid option for right now. Could you provide any time of timepath for this limitation to be fully dealt with for Pro users? Could we expect this within the current calendar year (2023) perhaps?

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      3 years ago

      Unfortunately I cannot say any such thing in this public forum, but we are working on a blog post that should shed some light on what you're asking. (By the way, congrats on the 500th message in this thread!)

      • FraukjeC's avatar
        FraukjeC
        Frequent Visitor
        3 years ago

        It has come to our attention that this issue has been solved! I have not found any official Microsoft communication regarding this, but we discovered it ourselves and found a blog post by A Guy In A Cube comfirming this (start at 5:23): 
        https://youtu.be/CIIzUvoUMOc?t=322

         

        jeroenterheerdt Would you happen to know if there is any documentation/release notes available somewhere on this?