Forum Discussion

ROG's avatar
ROG
Responsive Resident
4 years ago
Solved

Databricks and gateway

Hi all, My reports use databricks as datasource, and I was wondering if it's ok to schredule a daily refresh given that it's in the cloud. Or do I need to have a gateway for it? Thank you!
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi ROG ,

     

    If it is a cloud-based data source, then you can not configure the related gateway, but you need to configure the credential information of the data source.

     

     

    If you encounter problems when refreshing, it may be caused by the [BatchSize=null] parameter. Refer to the following blog for details.

    related link:

    Power BI - Azure Databricks | Microsoft Docs

    How to Fix Azure Databricks Refresh Issue in PowerBI.com – business intelligist


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

     

     

     

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi ROG ,

 

If it is a cloud-based data source, then you can not configure the related gateway, but you need to configure the credential information of the data source.

 

 

If you encounter problems when refreshing, it may be caused by the [BatchSize=null] parameter. Refer to the following blog for details.

related link:

Power BI - Azure Databricks | Microsoft Docs

How to Fix Azure Databricks Refresh Issue in PowerBI.com – business intelligist


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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

 

 

 

 

venki_rav's avatar
venki_rav
New Member
3 years ago

Hello v-henryk-mstf 

 

Lack of clear documents, I have to ask this question here.

For a cloud based datasource, we can not configure a gateway. But the Power BI statement makes it look like we can select a gateway if we can. Below is the description in Power BI.

You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect.

 

Is it possible to setup a gateway for a cloud data source, Azure SQL for example, even though it is not needed?