power bi dataset refresh with power shell thrpugh SQL Agent Job

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

hi Anonymous 

For your requirement, I would suggest you use Directquery model in power bi.

1. Everytime we refresh or reload a report that is in a Direct Query mode, Power BI will retrieve the source data from the data source. So when you refresh the dashboard or the report, you will get the latest data. 

2. Scheduled refresh of Direct Query is scheduled CACHE refresh. 

3. Even scheduled refresh can happen minute-by-minute, but the dashboard and the report won't refresh minute-by-minute. The tiles on the dashboard refreshes about every fifteen minutes. Reference: powerbi-refresh-data

Or you could try to use Microsoft #Flow for it

https://www.businessintelligenceinfo.com/business-intelligence/self-service-bi/updating-a-powerbi-dataset-using-microsoft-flow-azure-functions-and-a-flic-button

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

Regards,

Lin