Forum Discussion
Connecting to a dataflow in workspace and adding more M code into the dataset in Power Query editor
I have recently created two dataflows in Service
Unfortunately the Workspace is not Premium so there are some Computed Objects I couldnt do like Append, Merge etc
This means that I had to do a wokaround. in the pbix file, I connect to the dataflows. then go into Power Query Editor and Merge some of the queries etc.
so there is M code in the dataflow AND in the pbix file
The Standards dataset connects to the dataflows. Note that the last time it was refreshed was the 22nd a manual refresh
the dataflows refreshed last night as per the schedule but the schedule on the dataset seems to be been turned off.
So the question is, Is there any way of refreshing a dataset over a data flow that sets it running after the dataflows have been refreshed?
So if they finish at 10:15 we can start the other at 10:20 automatically?
2 Replies
instead of scheduling the dataflow and dataset refresh it would be nice if that could be initiated via the REST API whenever the data source has updated.
Oh, wait, that is already possible. What is still missing, unfortunately, is the Dataflows Refresh History call. So you don't know when a dataflow has finished refreshing. Oh, wait, you can use the Notifyoption https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow#request-body
Once you receive the completion confirmaton you can then initiate the dataset refresh via API. You can send a notification on completion here as well.
This is great but I would have a clue how to get started with that. can you point me to the step by step guide for this?
the documentation is only helpful if you understand what your doing
