How to Fix Azure Databricks Refresh Issue in PowerBI.com

No comments

The full credit for this goes to the Guy in the Cube for his video where Adam talks about how to fix direct query to Azure Databricks models deployed to PowerBI.com . Unfortunately, this issue also affects import models as well. If you have an import model from Azure Databricks and you try to set up Refresh in PowerBI.com you are likely to see this message:

The issue is [BatchSize=null] parameter in the Source step for your Databricks sourced queries that looks roughly like this – = ApacheSpark.Tables(“https://YOURDATABRICSURL_HERE”, 2, [BatchSize=null])

 

 

In order to fix this, you need to delete the offending part of the code, so it looks like this – = ApacheSpark.Tables(“https://YOURDATABRICSURL_HERE”, 2) and then redeploy.

You now should be enter the credentials and set up refresh.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s