can you please tell me, how i can do to get an incremental refresh with power bi (pro licences) if it is not available, how can i do to reduce the time of refresh (i have a table wich contains 12 000 000 lines)
My work-around for incremental refresh is to download historical data into flat-files (CSV, JSON, TXT) and put in OneDrive/SharePoint. I pull these files into Power BI in the Query Editor and Append with query that retrieves "live" data.
I query the last date in my "historical" dataset to determine the start date for my "live" query--so it's always dynamic as I drop more "historical" files in my OneDrive/SharePoint folder.
I would start with one or a few of your historical files in a local folder, and use the Folder connector to connect to it. Power BI will write some Power Query M for you then. Use Combine & Edit to loop through these files and ingest them into Power BI.
Separately, use the OneDrive connector to connect to one of your files in SharePoint. Then swap out the "Source =" code in the Folder version with the "Source =" and related lines from the SharePoint version.