Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Set up schema

I am using Power BI embeded with Direct Query mode. My source is a MSSQL database with multiple schemas. I have the same set of tables in multiple schemas (it is our reasization of multy tenancy). Fo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is there any workaround that allows to create Datasource in Direct Query mode dynamically with setting the SQL statement?

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

Dynamically changing data source of published report is not available now. Please vote on https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8786290-ability-to-change-the-dat....

 

Currently the only way to change the connection string from Power BI Service is using the API Set All Connections,

However it only works for the dataset in DirectQuery mode (not work for SSAS live connection).

 

Best Regards

Maggie