Import data from ODBC

[Anonymous]

Hello all,

I´m new in Power Bi, and would need some help updating data imported from ODBC:

I have an historian of data in ODBC, with a table that increases a few lines every second every day.

I imported this table to Power BI, but now, when I update my reports in BI, it looks at the whole historian again, and the amount of data is so big that it takes too long.

What would be the best way to have BI maintain the old data in the report, and only add the new lines that have been added to my table from ODBC when updating my reports, without having to import the whole historian every time?

Thank you!

[v-chenwuz-msft]

Hi @Anonymous ,

You can refer to the following article to set up incremental refresh.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

Avoid the full refresh with Incremental Refresh in Power BI (Premium) - YouTube

Best Regards

Community Support Team _ chenwu zhu

[Anonymous]

Thank you for your reply.

Do I need to have Power Bi Premium for this?

[v-chenwuz-msft]

Hi @Anonymous,

Incremental refresh is supported for Power BI Premium, Premium per user, Power BI Pro, and Power BI Embedded datasets.

Getting the latest data in real time with DirectQuery is only supported for Power BI Premium, Premium per user, and Power BI Embedded datasets.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

How to:

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

[johnt75]

If the old lines do not change, and if the data has a timestamp for when it was created, then you can use incremental refresh to only pull in the most recent data. the first load will load everything, so that will take a while, but then subsequent loads only pull in the last few days worth.

[Anonymous]

Thank you for your reply.

I´ve tried with incremental refresh, creating the parameters RangeStart and RangeEnd, and adding the date/time filter to the column with the timestamp. I published the report, but I get an error when I try to update the file in my workspace:

If I go to settings, I see that data source credentials is disabled:

In gateway connections, it says that I don´t have any data gateway. And I tried clicking on "Install now", but when I open the file, I get an error saying that I don't have access, and I can't do anything else. 

Would you know what's the issue here?