Send data set directly to power bi

Scripts, SQL, .NET Framework
,
#1

Hello good afternoon all right?

I would like to know if there is a possibility of taking the data from my supervisor and sending it to a power bi? From CLP to Power Bi?

#2

Yes, it is possible to send data from FactoryStudio to PowerBI. The simplest way to do it is to load the dataset using the API ODBC.
To do it, go through the following steps:

  1. Download the SQLite ODBC Driver here.

  2. Open the ODBC Data Source, click Add button to add a new Data Source and select the SQLite3 ODBC Driver, then click Finish, like the image bellow.

    image
    image1111×795 203 KB

  3. A new display will be open, on the DataSource Name, fill in a chosen name, and then click Browse to select the db file.

If you desire to get the historian tags values, for example, go to your project path and select the file with the extension .dbHistorian.

Now you should be able to load these data directly in your PowerBI report by using the ODBC option.

Best Regards.
Tatsoft Team.