Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamics CRM live data

hello, I have developed some reports using OData feed from Dynamics CRM system and one local excel file then i published it into service. When we get new record or deleta a record in CRM system it d...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I have two datasets initially, one from CRM and other from excel which is only one column consist of some holidays. So, now i made it only CRM and holidays column i created as a table with in Power BI. Then i used Gateway with standard mode. which worked perfectly.

     

    Thank you.

     

    Best regards,

    Ravali.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-lid-msft ,

Thank you for your reply. 

That is true it only have import option. 

And when i set up a gateway for shcedule refresh it is not working. I am not understanding that. Is my data is having two sources one from CRM and one From local file does this is a reason for not able to setup a gateway?

Badly need help in this case. 

THANK YOU.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    I have two datasets initially, one from CRM and other from excel which is only one column consist of some holidays. So, now i made it only CRM and holidays column i created as a table with in Power BI. Then i used Gateway with standard mode. which worked perfectly.

     

    Thank you.

     

    Best regards,

    Ravali.

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,


      Glad to hear that you have resolved your problem. Thank you for sharing your solution, we believe it can benefit more users. If you have any other questions about this scenario, please kindly ask here and we will try to resolve it.


      Best regards,