Power Platform & Proxies

Creation of the abstract class for the repository layer

public abstract class PowerBiRepository<T> : IRepositoryAPI<T> where T : class
{
    protected IContextServicePowerBI PowerBiService { get; set; }
    protected PowerBiRepository(IContextServicePowerBI powerBiService) 
    {
        PowerBiService = powerBiService;
    }
    public virtual IEnumerable<T>? GetAll()
    {
        throw new NotImplementedException();
    }
    //etc...
}

Creation of the Proxies

FormProxy : Once we got the values of the Table “systemform” related to the form in which the PBI report is embedded. The data of [SystemForm] type will be mapped into an object [FormProxy[]] of type array.

var systemForm = serviceProvider.GetRequiredService<DataverseRepository<DataverseModel.SystemForm>>().FindAll(qe);            
var formProxies = systemForm
                        .Select<Entity, FormProxy>((Func<Entity, FormProxy>)(f => new FormProxy(f)))
                        .OrderBy<FormProxy, string>((Func<FormProxy, string>)(f => f.ToString()))
                        .ToArray<FormProxy>();//convert entities into array of proxy

TabProxy : Tab is contained in a form in the dataverse. This object will contain the form Id.

public static List<TabProxy> LoadTabs(string formXML, string formid)
{
      if (formXML.Equals(string.Empty))
            return null;

      FormModel formModel;
      var tabProxies = new List<TabProxy>();

      using (StringReader stringReader = new StringReader(formXML))
      {
          formModel = (FormModel)new XmlSerializer(typeof(FormModel)).Deserialize((TextReader)stringReader);
      }

      if (formModel != null && formModel.Tabs.Count > 0)
      {
          foreach (FormTab tab in formModel.Tabs)
          {
              tabProxies.Add(new TabProxy()
              {
                  Text = tab.Labels.FirstOrDefault<FormTabLabel>()?.Description,
                  Value = (object)tab.Id,
                  Name = tab.Name != null ? tab.Name : string.Empty,
                  FormId = formid
              });
          }
      }
      return tabProxies;
}

SectionProxy : Section is contained in a tab in the form and will contain the embedded PBI report. This object will contain the form id as well.

public static List<SectionProxy> LoadSections(string formXML, List<TabProxy> tabProxies)
{
    var sectionProxies = new List<SectionProxy>();
    FormModel formModel;

    using (StringReader stringReader = new StringReader(formXML))
    {
        formModel = (FormModel)new XmlSerializer(typeof(FormModel)).Deserialize((TextReader)stringReader);
    }
    if(formModel == null) { return null; }
    if (formModel.Tabs ==  null || (formModel.Tabs != null && formModel.Tabs.Count == 0)){ return null; }

    foreach (var tabProxy in tabProxies)
    {
      foreach (FormTabColumn column in formModel.Tabs.FirstOrDefault<FormTab>((Func<FormTab, bool>)(t => t.Id == tabProxy.Value.ToString())).Columns)
      {
        foreach (FormTabColumnSection section in column.Sections)
        {
            sectionProxies.Add(new SectionProxy()
            {
                Id = section.Id,
                Text = (section.Labels.FirstOrDefault<FormTabColumnSectionLabel>()?.Description == "" ? 
                      section.Name : section.Labels.FirstOrDefault<FormTabColumnSectionLabel>()?.Description + " (" + section.Name + ")"),
                Section = section,
                Name = section.Name,
                ShowLabel = section.ShowLabel,
                FormId = tabProxy.FormId
            });
        }
      }
    }          
      return sectionProxies;
}