Forum Discussion
unsupported data source if using a custom M function
I have a customer that wants to be able to have a report based on data from multiple databases. One thing they want is to be able to add new databases into the data model on demand when they want wit...
Hi there
As far as I know the data sources have to be created as part of the PBIX.
I do know that whilst you can modify existing data sources with parameters, you cannot add new data sources dynamically in the Power BI Service.
This might work for you if you want to update it via the API: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources
As far as I know the data sources have to be created as part of the PBIX.
I do know that whilst you can modify existing data sources with parameters, you cannot add new data sources dynamically in the Power BI Service.
This might work for you if you want to update it via the API: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources
Hello GilbertQ
Thanks for your answer.
Unfortunately update via API will not work for me as the datasource that I use is ODBC and it's not supported.
So, the only solution atm is to add new sources manually (if via API is not an option), correct?