Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Import data from ODBC

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....
Need Help
johnt75's avatar
johnt75
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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?