Forum Discussion

igorfernitycom's avatar
igorfernitycom
Regular Visitor
3 years ago

Pivot column and Power BI can't connect to data source

Hello, Maybe someone had simmilar issue.   I make in one step of power query of Power BI desktop a pivot column. And it all works on desktop version as I expect it to work. I can refresh it. All s...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi igorfernitycom ，

Does the report work fine in Desktop? Could you please provide the error message.

Best Regards,
Community Support Team _ kalyj

igorfernitycom's avatar
igorfernitycom
Regular Visitor
3 years ago

Hello,

 

It works on desktop version. On online version I recive screen like below. It is in my language but it says it can't connect to data source. Because of that it can't show visual elements.

 

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi igorfernitycom ,

    What does it say when you click see the details.

    Best Regards,
    Community Support Team _ kalyj

     

    • igorfernitycom's avatar
      igorfernitycom
      Regular Visitor
      3 years ago

      Thank You for Your help but  when I press it, it  says the same. That it can't connect to data source. That I should check data source or wait or contact somone...bla bla bla. Nothing speical.

      I will make another topic how to solve my problem without pivot column because it make the problem. Maybe somone will help.

      I have tried in power query of BI desktop to delete steps one by one and when I reach and delete making pivot column and publish it then it is ok in power bi online. So this step causes probelms. But probably there is easier way to solve my probem. I know how to do it in excel so in PB it is also possible to make.