Forum Discussion
Using date format while using a data set in Excel from Power BI
Good evening, I am having problem while using a data set from Power Bi in Excel. I have mainly 2 problems while creating pivot tables: 1- Numbers are not recognize as number but as text whic...
bharath_v thanks for your answer but does not solve my problem.
In fact, my data set already done as you say. Neverthless, the problem comes while you take the data set of Power Bi in Excel. At that moment, even though the format is properly done in PowerBi in Excel it is recognized as text.
To sum up, the problem is Excel while using the data set from powerBi.
Hi,
Meet too have the same problem, when I try to connect with power BI data set in excel. My date column in power bi is getting converted as text in excel. Have you got any solution for it ?
PBI-BroAdvocate II
Hi, I'm having the same problem. Did you come up with a solution?