Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
But when I using the query to input my designed qurey, there is one error comming, as property query not supported.
Is there some posibility to input the native query there?
best wishes
loujiang
Solved! Go to Solution.
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.
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.
Hi,
PBIDS files are designed only to store connection information, such as: Data source type (Databricks, SQL Server, etc.), Server and database details, Authentication method
They do not support embedding queries because PBIDS files are meant to guide users to the right connection settings, not predefine dataset transformations or filters.
Check if following approach works for you,
Use PBIDS for the connection, then apply the query in Power BI
Thanks,
Bhavin
Hello, Bhavin,
Thanks for the confirm. Is there some other automated method available to enable the native query? We would generate the sql query automatically and would like to generate Power BI Files with the connection and SQL applied to .
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |