Forum Discussion

BhanuPBI's avatar
BhanuPBI
Frequent Visitor
3 years ago

how to trigger message once we refresh the dataset in service.

Hi Team, Can anyone help. how to trigger workflow message to slack automatically once we refresh the dataset in power bi service. Actually, I created a dataset using the slack workflow url to power...
Need Help
BhanuPBI's avatar
BhanuPBI
Frequent Visitor
3 years ago

Hi lbendlin ,

 

I'd want to thank you for your update, even though I tried checking all privacy setting choices and searched for rebuilding the dataset, I have no idea how to do so. First, I need to know whether this strategy is feasible in Power Bi. If it's feasible, please let me know how I can do it. Any updates would be very appreciated.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    It is feasible but will require a lot of trial and error.  Your best option is NOT to attempt to merge data sources in Power Query. Instead, let the Power BI data model do the work for you through the table joins. If that is not an option then you will have to go through the documentation I referenced and validate each and every recommendation and limitation. No dynamic URLs.  Inline functions.  Keep everything in the same partition etc etc. There is no simple solution.