Power BI embedded with Odata on Dynamics 365 for Operation workspace

[jonsnowax]

Hi,

I have 1box azure VM and i have configured power bi embedded for 1box by following link https://blogs.msdn.microsoft.com/dynamicsaxbi/2017/07/29/accessing-analytical-workspaces-on-1box-env...

I have design report using Odata and embedding in workspace form by calling via below code:

PBIReportHelper::initializeReportControl("MyPowerBIReportResourceName", FormGroupControl1)

As I open the page to which this report is embedded, I am getting this error in the eventlog:

- <Event xmlns="schemas.microsoft.com/.../event">
- <System>
  <Provider Name="Microsoft-Dynamics-AX-PowerBI" Guid="{F2F6BC2F-51F1-4E56-A578-A3B7A5C6025C}" /> 
  <EventID>15</EventID> 
  <Version>0</Version> 
  <Level>2</Level> 
  <Task>13</Task> 
  <Opcode>0</Opcode> 
  <Keywords>0x4000000500000004</Keywords> 
  <TimeCreated SystemTime="2018-03-14T15:51:36.942871500Z" /> 
  <EventRecordID>116</EventRecordID> 
  <Correlation ActivityID="{AA74D24B-C735-4759-A72E-C598112E430A}" /> 
  <Execution ProcessID="24084" ThreadID="38360" /> 
  <Channel>Microsoft-Dynamics-AX-PowerBI/Operational</Channel> 
  <Computer>XXXXX</Computer> 
  <Security UserID="S-1-5-20" /> 
  </System>
- <EventData>
  <Data Name="pbiReportResourceName">MyOdataReport</Data> 
  <Data Name="typeName" /> 
  <Data Name="methodName">PBIReportHelper::importAndStoreReport</Data> 
  <Data Name="stackTrace" /> 
  <Data Name="exceptionMessage">Operation returned an invalid status code 'BadRequest'</Data> 
  </EventData>
  </Event>

Please let me know why the workspace is not able to show the report. I am using Dynamics 365 for Operation Platform 9.

I am getting this error on Dynamics 365 for Operation workspace "Failed to publish Power BI Embedded report".

Note: I am able to see same report via the report link section in workspace.

Thanks

[v-micsh-msft]

"

Microsoft-Dynamics-AX-PowerBI

"

Are you using the On-Premise Dynamics AX?

Just from the error message, it should be related to the Power BI Embeded service.

Please make sure the service is allowed to be connected with the 

PBIReportHelper

For urgent support, please consider rise a support ticket.

https://powerbi.microsoft.com/en-us/support/

Best regards,

Michael

[jonsnowax]

I am using a Azure VM. My Dynamics 365 for Operation instance is available publicly and it is not on-premise.

"Just from the error message, it should be related to the Power BI Embeded service.

Please make sure the service is allowed to be connected with the "

PBIReportHelper

Please can you let me know what do you mean by the above. How can I make sure that service is allowed to be connected with the PBIReportHelper.

Thanks

[v-micsh-msft]

Hi,

Apologize for not being clear enough.

Bad request error message usually happens when connecting to Power BI Service through the Gateway service.

Mostly relates to the configuration of the gateway.

For your scenario,  the steps for connecting should relates to the step 4 in the guide you mentioned:

4.Configure the local 1Box environment to point at your Power BI Embedded service

Please check that part first.

Regards,

Michael

[jonsnowax]

Thanks for pointing out. I was already following the article suggested by you. However, I found issue in the login user account. After correction, I am able to view the reports in Analytical tab.

Thanks !