Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dataflow refresh with linked tables

I have a premium p1 SKU.    Dataflows are in a premium workspace.    Dataflows feed into several datasets.         Question:    Previously, I was updating each dataflow in a schedule like this:   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin   Yes, I would love to go that route, but our IT dept has disabled that ability due to data sharing policies.   So I'm back to my original question as to what is the best way to handle the refresh of the (for example) 2023 and 2023 dataflows, and the "all" dataflow (which contains both of these dataflows), then the dataset itself.   Thoughts?

lbendlin's avatar
lbendlin
Super User
2 years ago

You can recreate the Power Automate features with calls to the Power BI REST API.  Or did your IT department block that too?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    lbendlin  I have never tried it, but looking at the documentation it seems to say that this requires a service prinicipal account, which I do not have.    

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      I am using it with my regular AAD account.  Don't let the name of the login cmdlet throw you off.