Forum Discussion
Advocate IPower BI Service Connector Bug.
Hi All,
I installed the lastest version of the Power BI Desktop and I noticed that everytime I select the Power BI Service data connector it automaticly switches the SSAS connector after selecting a Power BI Service source. This means that I cannot switch from a test source to a production source.
Version: 2.50.4859.782 64-bit (september 2017)
With kind regards,
Daan Damhuis
Hi daandamhuis,
According to my test, the issue is gone in the latest Version: 2.52.4921.581 64-bit (November 2017). You can try it out.
Best Regards!
Dale
7 Replies
v-jiascu-msftMicrosoft Employee
Hi Daan Damhuis,
It's a live connection, which is just similar with SSAS live connection. You can reference powerbi-desktop-report-lifecycle-datasets/#limitations-and-considerations for details.
>>>Since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.
According to my test, it's easy to switch the data source. Open the connector, select the new dataset you want. Done.
Best Regards!
Dale
daandamhuisThis doesn't work in my version.
If i select the Power BI Online Service connector, it automaticly changes the connection type to a SSAS Live connection. So when I publish the report, it automaticly creates a new data source. Which is not the desired effect, and beside that I cannot change to a datasource in an other workspace. So when I publish from Acceptance to Production, it creates another data source in the production workspace.
In the end, I have 12 PBI data sources in the workspace for two cubes.
- v-jiascu-msft
Hi daandamhuis,
1. Is your original data source SSAS?
2. Why do you switch the dataset from one to another? We can say the connector Power BI Service aims at sharing a single dataset. Why not create reports based on the production dataset?
3. Could you please post some snapshots?
Best Regards!
Dale