Forum Discussion

daandamhuis's avatar
daandamhuis
Advocate I
8 years ago
Solved

Power 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 selecti...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

daandamhuis's avatar
daandamhuis
Advocate I
8 years ago

This 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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

  • daandamhuis's avatar
    daandamhuis
    Advocate I
    8 years ago

    FYI, this worked before in de August Version. 

     

    1. Is your original data source SSAS?

    Yes, Tabular. 

     

    2. Why do you switch the dataset from one to another?

    Deploy the same report to several workspaces and just have 1 data source for 1 SSAS Cube in each workspace instead of having serveral because each time a Data Set doesn't exists with the report name, Power BI just creates a new one (See 4). 


    We can say the connector Power BI Service aims at sharing a single dataset. Why not create reports based on the production dataset? <= Because we do User Acceptance tests of Model and Reports in a specific Workspace / App before deployed these to the production envoironment. 

     

    3. Could you please post some snapshots?

    1) Get Data - Power BI Service2) Select Data Source - Power BI Service3) Connected - Live Connection to SSAS instead of Power BI Online4) Report Deployed - New Data Source Created instead of using the TST data source that I pointed to in the "Get Data"

    • daandamhuis's avatar
      daandamhuis
      Advocate I
      8 years ago

      No one has a solution or the same issue?

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi daandamhuis,

         

        I tested it again today. It works in Power BI Desktop July as the documentation describes. I will submit a report at once. The workaround could be creating reports in the Service. Sorry for any inconvenience. Any updates will be posted here.

         

        Best Regards!

        Dale