Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Replace custom SQL datasource with dataflow

l have apublished report that uses a custom SQL as its datasource.  I created a dataflow using the M-code version of that SQL.  It is published, refreshes, etc with no issues.   Now I want to take ...
Dataflow
datasource
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Appreciate the feedback, but that link is giving you instruction on how to set up a dataflow.  I've already done that.   And I've brought it into my PBIX as a new datasource.

     

    Now I have 30+ visuals, that are currently using the SQL-based datasource.  I want them to reference the new dataflow instead.  But I can't seem to find any tips on how to do that.  

     

    Ultimately I have a number of workbooks using this SQL.  They all have their own datasource that needs to be refreshed.  I'm trying to replace all of those individual datasources, with one standardized dataflow.  

     

    In order to do this, I need to tell the PBIX to use the dataflow instead of the SQL.  I can then delete the individual datasources and will only have to refresh the single dataflow each day.