Power BI tables in Power Query

Question

hello!&nbsp;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 &gt; Get data &gt; from Power BI, I dont see such a option when I can open Power Query Editor...Please help&nbsp;thank you

greg_deckler · Answer

mail2maciek&nbsp;Are you trying to do this in the Service? If so, would suggest you do it in the Desktop.

mail2maciek · Answer

Dear&nbsp;Greg_Deckler thank you for your answer.&nbsp;my work environment is Excel with Power Query and Power BI web service. I can not download anything else as that states company rules.&nbsp;Can I do someting in this configuration?

greg_deckler · Answer

mail2maciek&nbsp;So edit the query in Excel?

mail2maciek · Answer

@Greg_Deckler this is what I wanted to omit and do on the fly in power query

greg_deckler · Answer

mail2maciek&nbsp;I don't believe you have that capability in the Service unless you implement it as a dataflow.

Forum Discussion

Power BI tables in Power Query

5 Replies

Related content

Matrix table in Power bi

Dynamic Public Holidays Table (Power Query / Power BI)

Power Query Tables

Power Query doesn't match Power Bi Table view

Power Automate is free with Power BI Pro Licence