Developer forum

Forum » Integration » Power BI integration

Power BI integration

E-mail notifications
Anders Thoresen
Anders Thoresen
Reply
Posted on 22/08/2023 12:21:46

We have a client that wants to be able to access certain data from DW and use into Power BI.

Is there any "easy" way of doing this? Or maybe its done before?

We are thinking to expose data through and API endpoint, but thought it would be good to check what alternatives there is.


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 22/08/2023 14:26:27
Reply

Hi Anders

I think you have a number of options depending on what data you want to expose.

  • The webapi (For searchable structured data - i.e. product data)
  • A query publisher using a Lucene index (Any data in Dynamicweb can be indexed using a SQL builder - makes the data searchable)
  • Using the datalist (Creating SQL to expose data - using a layout template that generates a feed in XML, jons, csv or similar
  • Custom controller that exposes any data in your desired format
  • Export module that can export data into XML, CSV, Excel etc.

So what data do you want to expose - and in which format?

BR Nicolai

 
Anders Thoresen
Anders Thoresen
Posted on 22/08/2023 14:58:28
Reply

Hi Nicolai, its mainly sales related numbers, amounts and similar to be able to track trends, sales and predict the market.

You anyway confirmed what i was thinking (and added a couple of alternatives), thank you!

 

You must be logged in to post in the forum