Extracting Data from IDN to PowerBI

Hi Mark, the stuff on here is very interesting. I didn’t know there was a more direct route to get to PowerBI. For the last 2 years I have been working on trying to get PowerAutomate to do this for me. Although I have had many successes in that and works a treat, the one thing I couldn’t figure out was to get it from JSON to a format that PowerBI can digest or CSV to a format that PowerBI with absolutely no manipulation. So 100% automated from beginning to end. I too have been looking at alternatives to dump the data into a Data warehouse or other Data modelling alternative but I haven’t got access to either in my role so that is my blocker currently, but I do believe that it would work. My workflows I build are currently for quick onboarding of applications, and in the past everything around Campaign Status reporting! Keep it up and please do share another step by step process on how we do this and I am keen to learn this from you.

1 Like

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.