Forum Discussion

Victormar's avatar
Victormar
Helper V
1 year ago

Incremental refresh on Azure Databricks datasource

Hello community, I am trying to work around the icnremental refresh using Azure Databricks as a source. The thing is that up until this point, we are working as well with parameters, to select diffe...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Victormar ,

Based on your description, I found some possible approaches to this issue, you can try to use Databricks.Query to load the table or still use Value.NativeQuery to get it. Of course you can also find the gear button next to source on the right side of the power query interface, you can click on it and go to the navigation interface, he will show all the tables and you can import the tables you need here.

Regarding Incremental Refresh in Power BI with dat... - Microsoft Fabric Community
Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn
Databricks Power BI Connector Native Query | Databricks Blog

 

Best regards,
Albert He

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

  • Victormar's avatar
    Victormar
    Helper V
    1 year ago

    Hi Anonymous ,

    Thanks for your answer. I have been reading through the links, and tried to implement some of them. I had tried a similar approach before.

    I think my "problem" is that I want to use a parameter to select which database I want to point to. I have DEV, QA & PROD, and it cannot be translated to a native query I believe. 

    Best Regards,