I have a Live connection report whose data source is pointed to an Azure Analysis Services database on server "A". We migrated the data model to server "B", and I want to update the Data Source settings for my report to redirect to the new server path.
In the past, my standard method has been Transform data -> Data Source settings, update the server & database paths, and click OK. It worked, it was solid, and didn't break. This option no longer exists as of the Oct 2022 Power BI Desktop release, as far as I can tell. The Data Source settings option instead opens the Data hub window.
I am now only able to select existing published workspace datasets as the new data source for this report. I do not see any other method to re-assign the data source without creating a local model (which is unnecessary in this situation, unwanted, and not reversible). My only other alternative is to create a new report with the updated AAS dataset connection, publishing it to the workspace, using Data hub to reassign the dataset, and deleting the blank report. That is too many steps for a function that used to take 2 clicks.
In addition, the Global Data source settings option has also been replaced by the Data hub window. There is no longer a method to update or clear my global or local credentials within Power BI. I do not see any Preview features that are related to this functionality, so I do not know of any way of disabling this aside from rolling back the latest version of Power BI.
At the very least, the Data hub should be associated with a Preview feature before overriding existing functionality.
on:
URGENT!! Paginated Report not loading on Mozilla F...
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX