Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone!
I need to bring in Power BI customer dimension from Dynamics Business Central: each customer has a region as its dimension (Table 18 of Dynamics). However, using Dynamics functionality (i.e. Web Services) I'm not able to connect to the table itself, I have to use Pages or Queries. I found 2 pages that should contain the information I need (DimensionValues and DimensionLines). I can easily bring DimensionValues in Power BI, but when it comes to DimensionLines, I got the following error message:
"DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You must specify a parent id to get the lines. CorrelationId: SomeValue.)"
It seems I need to "pre-filter" Navigation step in some way but I have no idea how to correctly replace [Data] with [Data With Filter]. In addition, because of this error I can't even see a page structure so I don't know what columns are present there and how they are called. I wish I could load only first row, understand DimensionLines page structure and then filter the correct column with a value from DimensionValues table.
Thank you!
Hi @Sergii24 ,
Maybe you can refer this document about connecting to Dynamics:
Use Power BI with Microsoft Dynamics 365
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.