Power BI Dataset CI/CD Pipeline (Azure Dev Ops, XMLA Endpoint, Tabular Editor & Service Connection)

Поділитися
Вставка
  • Опубліковано 19 лис 2024

КОМЕНТАРІ • 21

  • @ZachRenwickData
    @ZachRenwickData 2 роки тому

    This is awesome. Current client is still not ready for devops deployments of Power BI (can barely get them to use JIRA/tickets to track their work), but in the future I would love to implement this sort of thing in an enterprise environment.

  • @AgulloBernat
    @AgulloBernat 2 роки тому

    Man, this is from another universe, great job

  • @CallumLawn
    @CallumLawn 2 місяці тому

    Did you ever manage to incorporate the data source mapping into the pipeline?

  • @sacoroth42
    @sacoroth42 6 місяців тому

    Great video. One quick thing: is there a reason why your cursor is hidden? Maybe you've updated this on more recent videos but it can be tricky to follow along and see exactly where you are clicking on the screen in the various steps.

  • @Swoopss
    @Swoopss Рік тому

    Awesome !!
    Is it possible to switch to different workspaces when deploying?

  • @gabrielmorais7312
    @gabrielmorais7312 2 роки тому

    Very good.
    If you figure out if it's possible to set credentials as you said at the end (especially Sharepoint or Dataflows datasources) please let me know!!

  • @matthewcarter4266
    @matthewcarter4266 2 роки тому

    Awesome, awesome, awesome. Thank you 🙏

  • @marto9555
    @marto9555 2 роки тому

    Awesome video. This has really helped me deploy a CICD process into my business but I’ve hit a stumbling block!
    When I deploy my tabular model, it strips out all of the members to the RLS security roles.
    I can’t find any documentation on how to resolve this but I was hoping to use a PowerShell script, TMSL Script, or a XMLA cmd to add those members back into their roles post deployment.
    Can you help?? Or perhaps help understand why it strips them out in the first place.
    Cheers bud

  • @talcohen6842
    @talcohen6842 2 роки тому

    Hi! Thanks a lot for the great video! very helpful!
    Do you think it's possible to scale it to multi-tenants?
    I am developing an application in which each paying customer has his own Azure AD separate tenant which contains his own PBI dataset.
    I want to be able to deploy the datasets automatically to each tenant using Azure DevOps.
    Is it possible? any idea where I can find instructions and guidance?

  • @dbszepesi
    @dbszepesi 2 роки тому

    Great video!

  • @hma262
    @hma262 2 роки тому

    Thanks for this!

  • @jagatkrishna1543
    @jagatkrishna1543 2 роки тому +1

    Thanks Sir 🙏💕

  • @MijalisMendiz
    @MijalisMendiz Рік тому

    Hi thanks for the great video! I'm trying to replicate what you did and I'm getting this error when trying to deploy: ##[error]Deployment failed! The connection string is not valid.
    Do you know what might be the problem? My service connection verifys succesfully, the XMLA endpoint is ok and I couldn't find any other detail about the error
    Thanks!

    • @MijalisMendiz
      @MijalisMendiz Рік тому

      Nvm it was the Tabular Editor version. In your repo there is no link and I used the Daniels Otykier script (which downloads an older version 2.12.4). Using the same version as you did it worked fine.

  • @syedJunaid-ce8yq
    @syedJunaid-ce8yq Рік тому

    Do we need power BI premium for this complete process?

    • @johnnyw5627
      @johnnyw5627 Рік тому

      The prerequisites are covered in the bookmark at 27 seconds. Yes, you need Power BI premium

  • @iadgroe
    @iadgroe 2 роки тому +1

    Nice, but wow did I get blocked hard on a difference in the connection string:
    Deployment failed! The connection string is not valid.
    Cmd.exe exited with code '1'.
    In fact after then bumping into Daniel's video where he shows a part of his connection string, he in fact adds "Provider=MSOLAP;" (ua-cam.com/video/BbYqcSUXOgU/v-deo.html) which I had to include in order to make the connection. The nice thing is that locally though I did not need to add this... frustrating to say the least.

    • @GreyskullAnalytics
      @GreyskullAnalytics  2 роки тому

      Is that not for an Analysis Services deployment though? According to the MSFT docs the provider doesn't need to be specified for XMLA endpoint in the PBI Service. Certainly I didn't need to do that in the example demoed here, nor in the implementations I've done with clients

    • @iadgroe
      @iadgroe 2 роки тому

      @@GreyskullAnalytics yes I'm facing this for a power bi deployment (ppu) I know it deviates, but for me currently it does not work when leaving it out...

    • @guices
      @guices Рік тому

      Hi, did you make it works? I'm facing the same problem

    • @guices
      @guices Рік тому +1

      Quick Update: after add "Provider=MSOLAP;" it worked!