Forum Discussion

GK600's avatar
GK600
Helper II
6 years ago
Solved

Increment Refresh Clarifications

Hi,   Hope someone can help. I have read through a lot on incremental refresh but still stuck on many points. I don’t understand tech related stuff on data yet but progressing so apologies for any ...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    Yeah, sorry GK600 - I understand. That is how it goes with self service projects. If you can get the system to export in to Excel format or CSV format, you can get things working, but there will be no incremental refresh on those either, the point of your original post.

    If you have any problems going forward, start a new thread and we will jump in and help. In the mean time, please mark one or more of these posts as the solution so this thread can be marked as solved - even though not solved in the way you were hoping. 😉

GK600's avatar
GK600
Helper II
6 years ago

Thansk for your response. Appreciated.

 

I will check about query folding from API supplier just in case. I may also need to explore other database etc. which I dont have much visibility on. Is it usually available wthin organizations? I will be checking with IT team and if they feel comfortable about providing access. They last told me that we have E5 license. Not sure if that grants some sort of database access.

 

By the way, is there a way I can smoothen the process with POwer BI as of now to transform and build reports. It loads everytime I click close and apply. That takes about 1.5 hours. I thought that the data is already pulled and there must be a way to store differently to not allow PQ to connect to API every time I make small transformation within it.

 

Any pointer will be appreciated.

 

Gaurav

 

 

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi GK600 ,

If you want to create and connect databaselike Azure SQL etc, you need access/subscription from your organazation; if you want to connect to sql server, you can try an instance from here.

"is there a way I can smoothen the process with POwer BI as of now to transform and build reports"

If the connection mode is import or direct query, it is inevitable to use power query to transform data because it needs to create a data model in power bi; if the connection mode in Connect Live, although it will not use power query, it will have many limitations under this mode. You can refer to this document and choose the connection mode according to actual needs

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.