Forum Discussion
Power Query Error "AutoPremiumInvalidIndex" when using merge query
Hello JohnMarkPerez,
Have you tried saving a dataflow or a datamart here? There are various transformations that can only be done with Power BI Premium. In a dataflow, this is displayed with a lightning bolt.
Best regards from Germany
Manuel Bolz
🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github
aha Yes, the query have the icon when using merge query. Does this mean i need premium licens to run this query? and can i use PPU licens for this?
Hello JohnMarkPerez,
Can you run your query without the merge? Your error message indicates another possible problem.
Best regards from Germany
Manuel Bolz
🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on GithubBy removing the the merge query, the bolt icon disappear and i can run the query with no error. Note i have a pro licens.
Hello JohnMarkPerez
if your merge absolutely has to be created in the dataflow, Premium is required. If you have an SQL data source, the problem could also be solved with views. Or there are other creative ideas?
Best regards from Germany
Manuel Bolz
🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github