Forum Discussion
Manager Effectiveness template - can't refresh or identify dynamic data source after publishing
Hi VI_Migration and VI_Migration, thank you for flagging the issue.
We looking into this and noticed this report allows you to use either an OData link or a link to a .csv file as a data source. That is what seems to be causing the issue. We will take the action to limit the data source options to OData link only and let you know when the updated version of the PBI template is available in the product (expect it will take about 3 weeks). Our apologies for the inconvenience!
I get the same behaviour! I'm also unable to locate which data source it is referring too... think someone from the product team will need to feedback on this one 🙂
Thank you so much for checking!
I love seeing how they build their templates - I have learned a lot from them
Florine_SegersMicrosoft
Hi VI_Migration and VI_Migration, thank you for flagging the issue.
We looking into this and noticed this report allows you to use either an OData link or a link to a .csv file as a data source. That is what seems to be causing the issue. We will take the action to limit the data source options to OData link only and let you know when the updated version of the PBI template is available in the product (expect it will take about 3 weeks). Our apologies for the inconvenience!
Excellent. I tried changing the source line to this for both queries (just like the other templates), and that seemed to do the trick:
Source = OData.Feed(FileToUse, null, [Implementation="2.0", Concurrent = 1]),