Microsoft Sharepoint list and powerBI

%3CLINGO-SUB%20id%3D%22lingo-sub-2664749%22%20slang%3D%22en-US%22%3EMicrosoft%20Sharepoint%20list%20and%20powerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2664749%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20created%20with%20the%20new%20%22Microsoft%20Lists%22.%20One%20of%20the%20fields%20is%20a%20calculated%20field%20(called%20%22Estimated%20Cost%22)%20formatted%20as%20currency.%20Next%20step%20is%20to%20create%20a%20PowerBI%20from%20the%20list%20itself.%20All%20works%20fine%2C%20except%20for%20the%20fact%20that%20a%20visual%20that%20I%20want%20to%20show%20the%20Estimated%20Cost%20is%20shown%20not%20as%20a%20currency%2C%20but%20as%20text.%20Any%20idea%20of%20what%20it%20might%20be%20wrong%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ezequiel2235_0-1629373385409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304372i1F5D39721D77E99D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ezequiel2235_0-1629373385409.png%22%20alt%3D%22ezequiel2235_0-1629373385409.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ezequiel2235_1-1629373465443.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304373i58DA8DE43FA33854%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ezequiel2235_1-1629373465443.png%22%20alt%3D%22ezequiel2235_1-1629373465443.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThis%20is%20how%20the%20field%20is%20set%20in%20the%20list%20configuration%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ezequiel2235_2-1629373538090.png%22%20style%3D%22width%3A%20328px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304374iFD37C423850E5CF4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ezequiel2235_2-1629373538090.png%22%20alt%3D%22ezequiel2235_2-1629373538090.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEzequiel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2664749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2664897%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Sharepoint%20list%20and%20powerBI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2664897%22%20slang%3D%22en-US%22%3EI%20think%20you%20have%20hit%20a%20bug%20here%2C%20there%20is%20nothing%20wrong%20with%20the%20list%20but%20IMHO%20the%20problem%20is%20with%20the%20Power%20BI%20integration%3C%2FLINGO-BODY%3E
Microsoft

I have a list created with the new "Microsoft Lists". One of the fields is a calculated field (called "Estimated Cost") formatted as currency. Next step is to create a PowerBI from the list itself. All works fine, except for the fact that a visual that I want to show the Estimated Cost is shown not as a currency, but as text. Any idea of what it might be wrong?

 

ezequiel2235_0-1629373385409.png

 

ezequiel2235_1-1629373465443.png

This is how the field is set in the list configuration:

ezequiel2235_2-1629373538090.png

 

Thanks

 

Ezequiel

2 Replies
I think you have hit a bug here, there is nothing wrong with the list but IMHO the problem is with the Power BI integration
Thanks...I wanted someone else to confirm I was not doing anything wrong.