Forum Discussion

DN27's avatar
DN27
New Member
6 years ago
Solved

Power BI Report with Dynamics 365 Supply Chain using Odata live refresh

Good day!   We have created a Power BI Report which uses Odata connectivity to talk to Dynamics 365 Supply Chain (previously was part of Finance and Operations).    The problem starts after we pu...
dataflow
General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI DN27,

    I don't think 5 minutes of refresh frequency is possible on general connection modes.
    Perhaps you can try to create a streaming dataset that refreshes every time or try to use direct query mode.(it refresh every time you interact with its data)

    Real-time streaming in Power BI 

    Data refresh in Power BI 

    Regards,

    Xiaoxin Sheng

DN27's avatar
DN27
New Member
6 years ago

Hi Xiaoxin 

 

Can you confirm if we can use Direct Query with Azure SQL DB or Data Lake and will it allow me to refresh my dataset in real-time meaning can i keep a schedule of min every 5 mins interval refresh rate?

 

Cheers,

Dilip

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI DN27,

I don't think 5 minutes of refresh frequency is possible on general connection modes.
Perhaps you can try to create a streaming dataset that refreshes every time or try to use direct query mode.(it refresh every time you interact with its data)

Real-time streaming in Power BI 

Data refresh in Power BI 

Regards,

Xiaoxin Sheng

  • DN27's avatar
    DN27
    New Member
    6 years ago

    Hi

     

    Finally we went LIVE using Direct Query Option and auto page refresh in Power BI Desktop mode which is a workaround as we cannot invest in buying Power BI Premium license which offcourse is a "Premium" cost as the name suggests.

     

    Thanks for all your help

     

    Cheers,

    Dilp