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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.