Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello!
I have Power Bi source available in Excel, but unfortunately the one of the dimension data is to detailed.
My idea is to open Power BI table in Power Query, remap dimension and then return in to Excel.
Unfortunately despite I see the Power BI source when I open Data tab > Get data > from Power BI, I dont see such a option when I can open Power Query Editor...
Please help
thank you
@mail2maciek Are you trying to do this in the Service? If so, would suggest you do it in the Desktop.
Dear @Greg_Deckler thank you for your answer.
my work environment is Excel with Power Query and Power BI web service. I can not download anything else as that states company rules.
Can I do someting in this configuration?
@mail2maciek So edit the query in Excel?
@mail2maciek I don't believe you have that capability in the Service unless you implement it as a dataflow.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.