Schedule Automatic Update PowerBI ReportServer x DataBricks

[igorpereiradaco]

Dear all, I have successfully connected Power BI RS to DataBricks. However, when I published it on Power BI Report Server, there was an error in both the Direct Query to visualize the data. I tried in Import mode and was able to view the data, but I was unable to schedule automatic updates.

I searched the documentation to find out if Power BI Report Server supports DataBricks, but I didn't find anything talking about it.

Could anyone tell me?

[Anonymous · Accepted solution]

Hi,@igorpereiradaco .I am glad to help you.
Maybe you could try using ODBC as the connection method, there is user feedback that this works.
URL:

Solved: Access Databricks Delta table using SSRS without c... - Databricks Community - 29059

Also for Direct Query connection mode, the pbix data source may not be trusted by the system (data source credentials do not pass), so you can try adding it as a system environment variable.
I hope the following issue will help you.
URL:

Solved: dd - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[igorpereiradaco]

Thanks for the information.