Forum Discussion

loujiang's avatar
loujiang
Frequent Visitor
1 year ago
Solved

PBIDS File connect to Databrick cannot use query property

Hello, Dear Power BI community,  I am using the PBIDS File to make the connection to Databricks easier. I would also use some native query to make the connection more accurate and fit the need.  ...
Need Help
  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    If you need to apply a native SQL query, you can use Power BI Desktop by connecting via PBIDS and then entering your SQL query manually in Power Query’s Advanced Editor.

    For automation, you can generate .PBIX files dynamically using PowerShell, Python (pbi-tools), or the Power BI REST API by extracting a PBIX template, modifying the M script to inject your SQL query, and repackaging the file before deploying it to the Power BI Service.

    If you are using Power BI Premium, you can modify datasets programmatically using the XMLA Endpoint through SSMS or Tabular Editor, and automate query updates and dataset refreshes using Power Automate or REST API.  

BhavinVyas3003's avatar
BhavinVyas3003
Super User
1 year ago

If you need to apply a native SQL query, you can use Power BI Desktop by connecting via PBIDS and then entering your SQL query manually in Power Query’s Advanced Editor.

For automation, you can generate .PBIX files dynamically using PowerShell, Python (pbi-tools), or the Power BI REST API by extracting a PBIX template, modifying the M script to inject your SQL query, and repackaging the file before deploying it to the Power BI Service.

If you are using Power BI Premium, you can modify datasets programmatically using the XMLA Endpoint through SSMS or Tabular Editor, and automate query updates and dataset refreshes using Power Automate or REST API.