Comments

• 

  Steve Jeffery

  Tue, 3 Aug 2021, 8:34 PM

  Hi Daniel.
  
  Many thanks for the suggestions. Yes, we are using the service principal api access and our separate testing with our .NET application shows this is working as expected and has all the permissions required.
  
  From your point about the console messages, none of these appear and I can see they are part of the embed.js file. However, I can see this is not loaded. Can you think of a reason this js file is missing? It does not even attempt to load tis file.
• 

  Steve Jeffery

  Wed, 4 Aug 2021, 3:20 PM

  Hi Daniel
  
  I got to the bottom of it. It was a problem because of the use of cURL for https and for whatever reason was not seeing the microsoft endpoint cert as a trusted authority. Deployed cacert.pem resolved the problem. We're new to PHP so that did not help either. Maybe this will help someone else experiencing similar problems.
  
  Many thanks for your support and patience Daniel, the plugin looks great!
• 

  Emma Butcher

  Thu, 5 Aug 2021, 5:18 PM

  Hi, sorry last question! The filtering - I still can't seem to get this to work.
  
  To confirm - the first column in the list is for the Table Title? The second is for a field name? The report has multiple pages, would this make a difference?
  Thanks again, really does look great!
• 

  Daniel Neis Araujo

  Fri, 6 Aug 2021, 3:05 AM

  Hi, Emma!
  
  Yes, the first column is the "Table Title" on the report and the second is the "Field name".
  The third column is which field of the user profile Moodle will get the data from and send as the "Value" of the filter.
  You may have create filter on the report to be able to use it, but I'm really not sure.
  Please, let me know what you find.
  
  Best,
  Daniel
  
• 

  Diego Gómez García

  Wed, 8 Sept 2021, 6:32 AM

  Hey guys, first of all great job.
  
  ¿The only way to use is configuring with Azure Active Directory? I have an power BI account
• 

  Daniel Neis Araujo

  Thu, 9 Sept 2021, 5:09 AM

  You must create an OAuth2 app on Azure portal. If you have a Power BI Embedded account, you may be able to do so. If you use Power BI desktop, it's not possible.
• 

  Steve Jeffery

  Thu, 28 Oct 2021, 9:16 PM

  Hi. Is there a way to secure the report view page to a cohort? We understand a report can be associated to a cohort, but that does not seem to secure the report view page. The resulting view url is /blocks/powerbi/view.php?id=1 where a user once aware can simply change the id to view another report they should not have access to. Are we missing something?
• 

  Daniel Neis Araujo

  Fri, 29 Oct 2021, 2:20 AM

  Hello, Steve
  Thank you for reporting this!
  I've released a new version where I've added a check on view.php so now only users belongs to selected cohorts will be able to view the report.
  If no cohort is selected, no users will be able to view the report even if they know about the url - except they can manage reports, then they'll see all.
  Best,
  Daniel
• 

  Steve Jeffery

  Fri, 29 Oct 2021, 9:06 PM

  Hi Daniel,
  Thanks for coming back so quickly! We have applied the update but are still struggling. We have created a report and assigned it to a test cohort with a single user and then logged in as a different user (not in cohort) and navigated to the report view url and it still displays. Have we misunderstood how you are securing report access?
• 

  Steve Jeffery

  Fri, 5 Nov 2021, 1:04 AM

  Hi Daniel, just wondered if you had any update on the above security issue?
• 

  Daniel Neis Araujo

  Fri, 19 Nov 2021, 1:59 AM

  Hello, Stve
  Sorry, I've missed part of the code for the restriction. I've published a new version that may fix that. Please, let me know if now it works for you.
  Best,
  Daniel
• 

  Jins Thomas

  Tue, 28 Dec 2021, 1:26 AM

  Hello Daniel & Team,
  
  I am trying to set-up powerbi reports using our powerbi plugin, some areas are very grey for me, here are the steps i did, thank you in advance.
  
  - Installed plugin and I can access from Site Home => Power Bi -> Add/Manage Report
  - Created an account app dot powerbi and upgraded to pro
  - Created a workspace, and a sample report with a static data set (Gender report, Male, Female)
  - Copied the workspace ID and Report ID and try to configure the report in the moodle plugin area, , Report didn't come up.
  - But i also understand we need to do some more configurations which i'm a bit grey.
  - Is it okay if we keep Cohorts and Filter options empty, For me Cohorts says No Selections
  - I didn't understand where shall we configure Azure related configurations.
  - Kindly can you guide me some lights on this issue.
• 

  Daniel Neis Araujo

  Fri, 14 Jan 2022, 1:19 AM

  Hello, Jins
  You may have to create an App on Azure for Moodle to authenticate on Azure using it's credentials - app id and client secret that are configured on the plugin settings on site administration.
  
  Best,
  Daniel
• 

  Joshua Jago

  Tue, 15 Feb 2022, 11:55 PM

  Hi Daniel, I'm getting the following error showing in the console when I try to load a report:
  we have been started
  jQuery.Deferred exception: powerbi is not defined ReferenceError: powerbi is not defined
  
  Any idea why this may be happening?
• 

  Kimmo Kiiskinen

  Wed, 16 Feb 2022, 6:52 PM

  Hello Daniel
  
  I also have problems with this. After configuring everything, only white space is shown when viewing the report, with no error messages.
  
  I would be good to have clear steps that are needed to get the reports imported to Moodle.
  For example: Do we need specific Power BI license? Is App registration needed and if it is, with what permissions? Does the report in Power BI need to be in some specific form?