Forum Discussion
Set up schema
Hi Anonymous
Sorry for any inconvenience.
Parameters are not supported with DQ and LiveConnect today on the service.
For any workaround, you could use Power BI API.
But there are some limitations.
For example:
Updates the datasources of the specified dataset from the specified workspace.
- The original datasource and the new datasource must have the exact same schema.
- For cached models, the dataset must be refreshed to get the data from the new datasources. Wait 30 minutes for the update datasources operation to complete before refreshing.
- Changing datasource type is not supported.
- Datasources that contain parameters on the connection string are not supported
More details:
Updates the datasources of the specified dataset from "My Workspace".
Updates the datasources of the specified dataset from the specified workspace.
Best regards
Maggie
Is there any workaround that allows to create Datasource in Direct Query mode dynamically with setting the SQL statement?
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
Hi Anonymous
I'm so sorry that i am unable to help you efficiently.
If you have any problem, you could open a ticket to get more quickly help.
https://powerbi.microsoft.com/en-us/support/
Best Regards
Maggie