Forum Discussion
igorfernitycom
3 years agoRegular Visitor
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...
v-yanjiang-msft
Community Support
3 years agoHi igorfernitycom ,
What does it say when you click see the details.
Best Regards,
Community Support Team _ kalyj
igorfernitycom
3 years agoRegular Visitor
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.